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