How do I parse the data in a cell

[Randy]

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.

 

[Dave Peterson]

You could use Data|Text to columns
Delimited by a .
If there are no other dots in the cell.

 

[Don Guillett]

data>text to columns>delimited>other>.

 

[FSt1]

hi
you could use 2 formula to seperate the data into seperate cells.
first part before the period.
=LEFT(A1,FIND(".",A1)-1)
second part after the period.
=MID(A1,FIND(".",A1)+1,999)

each formula would go in a seperate cell from the data.
copy both formulas down as far as needed/
then copy the two fromula and paste special values.
this will turn the fromulas in to hard data. you can then delete the
original data.

Regards
FSt1