Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
search for text then return text | Excel Worksheet Functions | |||
Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
Fun with text functions - search for text | Excel Worksheet Functions | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
Search in a text box | Excel Discussion (Misc queries) |