Changing a Name in a cell

[Rebecca]

Hi! I want to change a name like "Beth Johnson" in a cell
to: "Johnson, Beth". I know I used to be able to do this
easily, but it is just escaping me now!!!

HELP!

Thanks!

 

[J.E. McGimpsey]

If you only have two names, here's one way:


=MID(A1,FIND(" ",A1)+1,255) & ", " & LEFT(A1, FIND(" ",A1)-1)

 

[JS]

hi, there's probably a better way to do this but this should work. select
the column with your data, go to data and text to columns. follow the
instructions which will result in the name being split into 2 columns. then
use a formula like the one below to create the format you require.
if cell A1 has the surname and B1 the first name
=B1 & " " & A1

 

[Rebecca]

This did it!

Thanks a BUNCH!!! You saved the day!! WOOT! EMPLOYED FOR
ANOTHER DAY - whew!