Hi MSA,

There is a function Text to Columns under the Data menu.
If you copy the data to column B and use the Text to Columns function under
the Data menu, choosing Delimited and comma as the delimiter, it will convert
the data into columns B and C

Anthony

"MSA" wrote:

Hi

I have a column A which has first and last name separated by a comma as
follows:

*Cloumn A*
Bernhardt,Gail
Wygonik, Mark
Patel,Arpna

Now, what I need is to be able to separate the two into 2 columns so I can
get, col. B and C:

*Col B* *Col C*
Bernhardt Gail
Wygonik Mark
Patel Arpna

Thanks for your help!
MSA