Extracting key words from a cell

[ronnie34]

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

[NoSparks]

Can you attach a small sample workbook showing typically what you're dealing with and indicating what the desired results would be ?

[ronnie34]

I've below attached a dummy example indicating what should appear on the right.
Note that RHS works, however LHS does not.

Many thanks for your help !!
Kind regards
Ronnie

[Pecoflyer]

Perhaps in C6: =IF(ISNUMBER(SEARCH("RHS",B6)),"RHS","LHS") and pull down as needed

[ArviLaanemets]

For C6, the one possible working formula will be

=IF(LEN(SUBSTITUTE(B6,"RHS",""))<LEN(B6),"RHS",IF(LEN(SUBSTITUTE(B6,"LHS",""))<LEN(B6),"LHS",""))