Changing Cell Contents

[Orion Cochrane]

I have an employee list with names (First Last) in one column. Is there a way
to get the last name to show up first and then the first name? TIA.

 

[Gary''s Student]

Assuming that the names are in a single cell searated by a single blank,
select the cells and run this macro:

Sub swapum()
For Each r In Selection
s = Split(r.Value, " ")
r.Value = s(1) & " " & s(0)
Next
End Sub

 

[JE McGimpsey]

One way:

A1: First Last
B1: =TRIM(MID(A1,FIND(" ",A1)+1,255) & ", " & LEFT(A1,FIND(" ", A1)-1)

 

[Orion Cochrane]

Tried the formula route, and it works awesome! Thanks. I can use this
elsewhere I bet.