infomercialscam
New Member
I have an excel spreadsheet with a single column, consisting of "Lastname, Firstname (group)" format. (ie: Guy, Tech (Support) )
How can I change the format in these text fields to first, remove the "(Support)" part, and then reverse the firstname/lastname, so all I have in the column (or another column) with "FIRSTNAME LASTNAME" (all caps would be good, but not required....)
How can I change the format in these text fields to first, remove the "(Support)" part, and then reverse the firstname/lastname, so all I have in the column (or another column) with "FIRSTNAME LASTNAME" (all caps would be good, but not required....)