Hi All
I compiling a best of the excel forums function combination solutions to attach to the forum
does anyone remember who need created this solution? I can find it any where
If you have any favorites please send them in .They will be credited to the author and added to the workbook. they can be one liners like
=IF(OR(ISNUMBER(SEARCH({"FOR","RPA","RGA"},B3))),RIGHT(B3,4),IF(OR(ISNUMBER(SEARCH({"LS","JU","SS"},B3))),LEFT(B3,MIN(FIND("^^",SUBSTITUTE(B3,{"LS","JU","SS"},"^^")&"^^"))-1),"")) from NBVC
Bookmarks