Hi, I'm trying to extract some key words from a cell on excell, these keywords being "LHS" and "RHS" from a string of text by using the formulas of FIND, MID, LEFT, RIGHT, TRIM and LEN
I have made the following progress of =MID(B6,FIND({"RHS","LHS"},B6),3)
However, whilst this works for the first cell as it returns "RHS", this is not the same for the remainder where the output should be "LHS".

I was wondering what i may have been doing wrong?

Kind regards
Ronnie