Changing Cell Contents
 

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.
--
I am running on Office 2003, unless otherwise stated.

Changing Cell Contents
 

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

--
Gary''s Student - gsnu200820


"Orion Cochrane" wrote:

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.
--
I am running on Office 2003, unless otherwise stated.

Changing Cell Contents
 

One way:

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

In article ,
Orion Cochrane wrote:

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.

Changing Cell Contents
 

Tried the formula route, and it works awesome! Thanks. I can use this
elsewhere I bet.
--
I am running on Office 2003, unless otherwise stated.


"JE McGimpsey" wrote:

One way:

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

In article ,
Orion Cochrane wrote:

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.