View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default How do I parse the data in a cell

datatext to columnsdelimitedother.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Randy" wrote in message
...
I have an excel workseet with the following type of data:
white-jungle.XL
white-jungle.XXL
jungle-smoke.S
berny blue-smoke.S
berny blue-smoke.M
I need to parse the 'sizes'(everything after the period) and put it
another
column.
Any help would be appreciated.