Search and Cut Text
 

Hi,
I have a set of data that has been imported and one cell contains a number
of descriptors i would like to seperate into seperate cells. Here is an
example row:
with / as the seperation between cells

Dog / $20 / Pet type Animal $15 Cat $0

What i would like to do is search through the last cell find the $ cut all
the wording before that (Pet type Animal) into a new cell, then cut the $
and put that in a new cell and so on.

So in the end i get this Dog / $20 / Pet type Animal / $15 / Cat / $0

I have about 200 cells that need this doing to them. my goal is then to
create a pivot table so i can sort on all this data

Any advice would be greatly appreciated

Search and Cut Text
 

Have you tried datatext to columns

"Anthony B" wrote in message
...
Hi,
I have a set of data that has been imported and one cell contains a number
of descriptors i would like to seperate into seperate cells. Here is an
example row:
with / as the seperation between cells

Dog / $20 / Pet type Animal $15 Cat $0

What i would like to do is search through the last cell find the $ cut all
the wording before that (Pet type Animal) into a new cell, then cut the $
and put that in a new cell and so on.

So in the end i get this Dog / $20 / Pet type Animal / $15 / Cat / $0

I have about 200 cells that need this doing to them. my goal is then to
create a pivot table so i can sort on all this data

Any advice would be greatly appreciated

Search and Cut Text
 

no i hadnt looks like a good idea, can i automate easily to cope with cells
that are not the same each time?
"Don Guillett" wrote in message
...
Have you tried datatext to columns

"Anthony B" wrote in message
...
Hi,
I have a set of data that has been imported and one cell contains a
number
of descriptors i would like to seperate into seperate cells. Here is an
example row:
with / as the seperation between cells

Dog / $20 / Pet type Animal $15 Cat $0

What i would like to do is search through the last cell find the $ cut
all
the wording before that (Pet type Animal) into a new cell, then cut the
$
and put that in a new cell and so on.

So in the end i get this Dog / $20 / Pet type Animal / $15 / Cat / $0

I have about 200 cells that need this doing to them. my goal is then to
create a pivot table so i can sort on all this data

Any advice would be greatly appreciated