Jorge,
You may find you'll need the first and last names separated into separate
columns, such as to do a sort by last name. You might want to consider
converting your table. Here are two formulas, just parts of Julie's
Last Name: =RIGHT(C14,LEN(C14)-FIND(" ",C14))
First Name: =LEFT(C14,FIND(" ",C14))
You could put these in a couple of columns (copied down with the fill handle
as necessary), then you could make it permananent, allowing you to remove
the original column with the full names. Select the columns, Copy, then
with them still selected, Edit - Paste Special - Values. Now remove the
original full name column.
Where needed, you could combine them into full names. If the last name in
C15, and the First name in C16, you could use
Doe, John: =C15 & ", " & C16
John Doe: =C16 & " " & C15
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
President Bush on sovereignty:
http://www.tastefullystated.com/sovereignty.wmv
-------------------------------------------
"Jorge" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello Excel gurus...
>
> I have a cell/column containing a persons name:
> John Doe
>
> I'd like to convert cell/column to read:
> Doe, John
>
> What formula is used in order to make this happen?
> I've tried left/right/len commands out the wazzoo (technical word) - I
> give... uncle....
>
> Any help?
> Jorge
>
>
Similar Threads
