Getting text out of strings

[CyberLady]

Hi all,

I'm trying to pull out two types of text from following string of data (located within one cell).

The text I want to pull out is not always the same size, and the text I need to pull out is not always in the same spot...

Since the text string will vary, I will here show you only two example;

Example 1
Text string

;#{1}Categories (Sub & Main);#{8}General Corporate Documents;#{29}Shareholder meetings /AGM;#

Text 1 that I want to pull out (red); General Corporate Documents
Text 2 that I want to pull out (blue); Shareholder meetings /AGM
//the pink numbers will also vary

Example 2
Text string

;#{1}Categories (Sub & Main);#{10}ICT;#{40}Frame Agreement;#

Text 1 to pull out (red); ICT
Text 2 to pull out (blue); Frame Agreement
//the pink numbers will also vary

Hope that someone with a brigth head can help me with this

Thanks in advance for your help!

 

[CyberLady]

Hi, and thanks for your fast respond. The code you sent works brilliant But, I need a "default code" for B1 and C1 - in other words if I have a text string as A1 or A2 or another - the B1 and C1 code should be able to get the text behind bracket #2 and #3....

Thanks!

Oh, my oh my....think I need some better glasses...seems as the code you have presented in B1/B2 and C1/C2 are the same. In other words what i really wanted....

Your are a fantastic code master!!!!

 

[CyberLady]

Oh, my oh my....think I need some better glasses...seems as the code you have presented in B1/B2 and C1/C2 are the same. In other words what i really wanted....

Your are a fantastic code master!!!!

Apologize for my stupidity with replying. I'm very new in this forum (got my account today)