Extract text from string with forward slashes

With
A1: some text delimited by slashes....Index/Revenue/High/5.2

Item 1:

Please Login or Register  to view this content.

Items 2, 3, and 4

Please Login or Register  to view this content.

Copy that formula across through E1

The results will be:

Please Login or Register  to view this content.

Is that something you can work with?

Use this & drag to the right.

=TRIM(MID(SUBSTITUTE("/"&$A1,"/",REPT(" ",125)),125*COLUMNS($A:A),125))

Now you have me confused. If you want to separate them, aren't they going to be in different cells... Can you post an Excel sheet showiung your desired results?

If you enter the one formula that I suggested, it will return one "word" in each cell. If you select B1-G1 and drag down, you'll do all of your data in one go.

OK... but credit where credit's due. I first saw ALKEY (another regular here) use this. In essence, it fins the delimiter - in your case a / and adds a lot of spaces (125) after it. The mid function then returns the first 125 characters (most of which are spaces) and trim removes the extra spaces; leaving the text to the left of the delimiter. As you drag it acrosss, it puts twice, three, four times the number of spaces in... which "as if by magic" separates the text at each delimitier.

Thanks ALKEY.

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.