Thread: Pull part text from cell

Hi there,

I'm trying to pull data from Cell A1 and place it into A2,A3,A4,A5,A6, however, the range may differ form anywhere between A2-A10.

I have created the below senario to help make it easy to understand...

Any help would be much appreciated...

Thanks for your time

Regards

SWM


A1= "Computer & Video Games > Categories > Game Hardware > GameCube > Cables & Adapters >"

A2="Computer & Video Games"
A3="Categories"
A4="Game Hardware"
A5="GameCube"
A6="Cables & Adapters"

Hi,
Have you looked at the Data->Text to columns feature? If those are meant to be '>' symbols in your post, then use that as the delimiter. if they are not, then you may want to use the Edit-Replace functionality to convert them to a delimiter that does not appear in your text, then use that to parse the data into columns.
HTH

thanks romperstomer... should have thought about that myself... great idea...

Thanks

SWM