Thread: cell splitting
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default cell splitting

Data Text to columns

Tim

--
Tim Williams
Palo Alto, CA


"Randy Patterson" wrote in message
m...
I have one cell which contains the first and last name separated by a

space.
I want to change this into two separate cells. The names are all different
lengths. I am unable to find any command to do this. Sort of a backwards
concatenate. Does anyone know how to do this?