Thread: Dividing name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Dividing name

Data Text to Columns Next select Space Next Finish


"kd" wrote:

I have a long coloumn with names and I need to divide them into first name
and last name. Is there a formula for the same.

Any help would be appreciated.

Thanks,
KD