Need help on excel

[infomercialscam]

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....)

 

[ttpicasso]

a vb script will do it easily.

If you want to email me the file i will do it for you, or send a small sample.

Paul

 

[ttpicasso]

This may look complicated but will do as you requested (where "A1" is the cell containing "Smith, John (Support)" )

=CONCATENATE(UPPER(TRIM(MID(MID(A1,1,FIND("(",A1)-1),FIND(",",A1)+1,LEN(MID(A1,1,FIND("(",A1)-1)))))," ",UPPER(MID(A1,1,FIND(",",A1)-1)))

put this into the cell/column to the right of your text and replace A1 with your cell reference, then to remove the formula, select the column, edit-copy, edit-paste special-values.

Hope this helps

Paul

 

[KnutHandsome]

The OP is a clever spammer.

Technique is to lift an old question from elsewhere, and post it with an embedded link (which has been removed here).

eg.

This question originates 2 years ago:
http://forums.techguy.org/business-applications/576329-need-some-excel-formatting-help.html

 

[ttpicasso]

Ah well, it still works