Thread: Split cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 860
Default Split cell

Hi Rexmann,

Select all of your data then goto DataText to Columns. In the wizard select
delimited then next then choose space as the delimiter and Finish.

HTH
Martin