View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Penny Penny is offline
external usenet poster
 
Posts: 33
Default Is there a way to separate into own cells?

I have xxx-xxx-xxxx(followed by a /) FirstName LastName xx-xxxx all in the
same cell (ie: 865-356-8434/Curtis Gogel 01-AUDT) but would like to have :
8653568434(no dashes)|Gogel, Curtis|01-AUDT.

Is it possible to "tweak" the excel cell info from ONE cell into three,
appearing as such listed above?