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.

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.

One way:

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

In article <3E530C15-FC02-4876-AE55-(E-Mail Removed)>,
Orion Cochrane <(E-Mail Removed)> 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.

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 <3E530C15-FC02-4876-AE55-(E-Mail Removed)>,
> Orion Cochrane <(E-Mail Removed)> 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.
>