How to search for multiple letters, & copy when certain letters are found.

Originally Posted by bebo021999

It seems the special thing always appear after the last "\"
If so, in C31:

=LEFT(TRIM(RIGHT(SUBSTITUTE(B31,"\",REPT(" ",255)),255)),3)

Drag down

This worked perfectly. I want to thank you for the huge amount of time you have saved me, sir.