How do I parse the data in a cell
 

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.

How do I parse the data in a cell
 

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



Randy wrote:

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

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.

How do I parse the data in a cell
 

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



"Randy" wrote:

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.