Assume that I have the following text in separate cells Example:
Cell A1:
Apple; Switzerland; Creative; Commodore 64
Cell A2:
Banana, Monte Carlo, iPod ; Atari
What I want is a function that always gives me the text between the second and third ";"
=>The result I'm looing for is " Ctreative" in cell A1 and " iPod" in Cell A2
I have problems to get the number of the senond position for ";"
Thanks,
Sven
Bookmarks