View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default Split the numbers in a alpha numeric case

Jp wrote:
I have the following Number format in one row

132-45-69 N.

I want to split the numbers in three different rows like 132 in one
row,45 in another and 69 in the third row.

Can this be done in excell


Use Data-Text to columns..., select delimited and specify space and hyphen
as delimeters.