Prev: Outlook Calendars
Next: compile data base on hit
From: Randy on 1 Apr 2010 19:46
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.
From: Dave Peterson on 1 Apr 2010 19:52
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
From: Don Guillett on 1 Apr 2010 19:53
data>text to columns>delimited>other>.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Randy" <Randy(a)discussions.microsoft.com> wrote in message
news:717BF04D-D318-482E-9F82-6369C75E3AF7(a)microsoft.com...
>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.

From: FSt1 on 1 Apr 2010 20:00
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.
 | 
Pages: 1
Prev: Outlook Calendars
Next: compile data base on hit