Finding multiple key words from a cell

[Ronnie10150]

Hi I’m trying to find the keywords of “LHS” and “RHS” in a cell, by only using the functions LEFT, RIGHT, MID, LEN, FIND and TRIM. I’ve tried the following formula

=MID(B6, FIND({“LHS”, “RHS”}),B6),3)
where B6, and all cells in that column contain fext, each of which have either LHS in or RHS in.
The problem I’m having is that whilst it works for the first cell, it does not work for the remainder.
I was wondering if anyone could help me with this and tell me what I’m doing wrong
Kind regards
Ronnie

 

[Fluff]

Hi & welcome to the board
Is this homework?

 

[Ronnie10150]

Hi & welcome to the board
Is this homework?

Hi and many thanks for the warm welcome!
And no this isn’t homework ! It’s just a problem I’m having as part of my work

 

[Fluff]

Not sure how to do it with just the functions you've listed, but you could do it like
=MID(B6,OR(ISNUMBER(FIND({"LHS","RHS"},B6))),3)