View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greg Greg is offline
external usenet poster
 
Posts: 331
Default split one column to multiple columns

I have data formatted in column A like:

Sheldon Barnes ,
Miriam DURVAMC Mil34ler ,
Eddie Barnes ,
Deloris Bell-Johnson ,
Brenda Bethea ,
jessie bowen ,

How can i separate into three columns?
First Name, Last Name, E-mail

Many Thanks in Advance
Greg