Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
search for text then return text r2rcode Excel Worksheet Functions 1 March 3rd 10 07:23 PM
Nested formula to search a text string and return specific text Barbie Excel Worksheet Functions 10 February 21st 09 07:40 AM
Fun with text functions - search for text mr tom Excel Worksheet Functions 7 October 26th 07 07:17 PM
Search, find or lookup defined text in text string zzxxcc Excel Worksheet Functions 9 September 6th 07 09:37 PM
Search in a text box Michael R Excel Discussion (Misc queries) 0 February 22nd 07 03:28 PM


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"