Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i parse every nth data point from a large data set in exce | Excel Worksheet Functions | |||
Parse row data in Excel | Excel Discussion (Misc queries) | |||
How to parse data | Excel Discussion (Misc queries) | |||
How to parse data | Excel Discussion (Misc queries) | |||
Parse Data to Various Columns | Excel Discussion (Misc queries) |