Text stuff...

[MarkyMark]

Hello.

Trying to switch position of names in a cell. Example,
trying to convert John A. Jones (in one cell) to Jones,
John A. in another cell.

I've tried Right, Left, ISERROR functions, but can only
seem to strip first name only. Please advise.

Thnak you.

MarkyMark

 

[Gord Dibben]

Try Chip Pearson's site

http://www.cpearson.com/excel/FirstLast.htm

And a downloadable workbook with examples.....

http://www.cpearson.com/excel/download.htm

Look down the list for FirstLast

Gord Dibben Excel MVP

 

[Myrna Larson]

If all of your names include the middle initial, you could use Data/Text to
columns to split into 3 columns at the spaces. If you started with the name in
A1, it would end up in A1:C1. To get what you want, in D1 =C1&", "&A1&" "&B1.