View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MSA MSA is offline
external usenet poster
 
Posts: 5
Default How can I extract the first & last name separated by a comma

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