Search and Cut Text

  • Thread starter Thread starter Anthony B
  • Start date Start date
A

Anthony B

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
 
no i hadnt looks like a good idea, can i automate easily to cope with cells
that are not the same each time?
 
Back
Top