Excel Change order of name data

[Rebecca]

Hi! I want to change "Beth Jones" to "Jones, Beth."
There used to be an easy way, but I've slept since
then....HELP!

Thanks!

 

[Richard Choate]

Are you wanting to make the change within the same cells, or are you willing
to write formulas to manipulate the text in one cell and show the result in
another?
Richard

Hi! I want to change "Beth Jones" to "Jones, Beth."
There used to be an easy way, but I've slept since
then....HELP!

Thanks!

 

[Chip Pearson]

Rebecca,

Try the following formula, with "Beth Jones" in cell A1:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)