View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Zygan
 
Posts: n/a
Default Converting Text String to Separate Numbers


try click on the cell and then click on DATA TEXT TO COLUMNS then you
have two choices Delimited wher spaces or commas or / marks will
serperate the text into cells or you have the option of fixed with wher
you can move the vertical lines to split the cell


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=549388