Hello excel experts,

May I know what's the formula to search for a particular string?

i.e. I have QUOT20140711-9527-5212a priced on Monday. SOMETIMES I do have a space in between '-'.
i.e. I have QUOT20140711-9527- 5212a priced on Monday. Notice the extra space after the '-' and before 5212a?

My question is then, how do I get 5212a in this case?

I know for sure that it'll be QUOT[YYYYMMDD]-(_)####(_)-(_)@@@@@@(_)priced on
where (_) is a space depending on user input (some uses a space in between hyphens '-'
@@@@@@ could be any "PO" number