[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