Dear Expert,
I want to get few specific words from a cell like cell a1= "George Ladies OPP Jogger #WBTPF-1056/1473/74/75 Balance (9500)".
I want to get from a1 to a2 "Ladies OPP Jogger" .
Here my first word is 1st word 'George" & Last word which word contain "#".
SO i need of these middle all words.

Please help me to get this formula.

Best Regards
Wahid