LEFT function of a certain word by a certain amount of characters

[willow1985]

Hello,

I am looking for a formula that can find a certain work and return only 10 characters to the left of that word.

For example

OTHER INFORMATION.... FOR PO# 55222 FROM COMPANY

Left of "From Company" I want it to return the PO# 55222

Any help would be appreciated

Thank you!

Carla

 

[Fluff]

How about
=MID(A2,SEARCH("from company",A2)-10,10)

 

[willow1985]

Works perfect! Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback