Line of text - Forumla Needed to Only Extract only part of it

[smerrick]

Hello,</SPAN>

I have in a cell the following:</SPAN>

BENEFICIARY= ######## ABCDEF</SPAN> INC</SPAN>

Is there a formula I could use next to it that would only give me the company name and ignore the word </SPAN>B'ENEFICIARY=' and the following 8 digit number (that can be random</SPAN> but always 8 digits).</SPAN>

Note that the company name at the end can contain any number of letters.</SPAN>

Any help would be appreciated.</SPAN>

 

[njimack]

=mid(a1,14,len(a1)-24)

 

[vds1]

=substitute(a1,mid(a1,1,find("#",a1)+8),"")