How do I convert last name, first name in cells to first name las.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Cells contain names in last name, first name order. I wish to convert to
first name last name (no comma) without retyping. Thanks
 
Assuming your data is in column A. Select the names in Column A. Make sure
that Columns B and C are blank. In Excel 2003, click on data,
text-to-columns and choose delimited and comma. The last name of the first
entry will be in A2 and the first name will be in B2. In C2 type =B2&" "&A2
to concatenate the name with first name first and then copy down the formula
in C2 as far as necessary. As a last step be sure to copy Column C, go to
Edit - paste special -values and paste back on Column C.
 
FWIW- Michael's reply should give you what you want if the data is
consistant, but I would offer another thought when it comes to the "In C2
type..." step on - leave it out. Store the first & last names in separate
columns in order to more easily produce true alpha sorts and filters, mail
merge, etc. based on the content of either field. You can always use his
concatenation formula to combine the content of the two fields for display
purposes, but it is very limiting to store it that way.

Even if your current needs don't require it, sooner or later it will pay
off. Make sense? |:>)
 
=?Utf-8?B?c291dGhlcm4=?= wrote
Cells contain names in last name, first name order. I wish to convert
to first name last name (no comma) without retyping. Thanks
Click to expand...

One more way:
=IF(A1="","",RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(",",A1)-1))
 
Back
Top