[thelist] Splitting the contents of an Excel cell
Feingold Josh S
Josh.S.Feingold at irs.gov
Mon Aug 19 14:25:01 CDT 2002
--
[ Picked text/plain from multipart/alternative ]
> No - can you change:
> FirstName Surname to Surname, FirstName ?
Take FirstName Surname and further split the information into two cells.
Now you have the firstname in cell A1 and the Surname in cell B1. In C1
type this formula: =B1 & ", " & A1. Then copy this data and paste special
as values only in D1.
There might be an easier way to do this, which I hope someone will share.
Take care,
Josh
More information about the thelist
mailing list