Formula help

Question

I need to pull out the text string which in the example below is "MVP623037 (Load ID)" however it is not always in the same place in the field. It could be the first string, second or last string between commas for example. How can I pull this out? Am I also able to only pull out the "MVP623037" in that string via formula?

1381207285 (PRO), MVP623037 (Load ID), MVP623037 (BOL)

------------------------------
Alycn Bjergo-Justen
------------------------------

1381207285 (PRO), MVP623037 (Load ID), MVP623037 (BOL)

------------------------------Alycn Bjergo-Justen------------------------------

MarkShnierYou · Answer

This might workRight(Trim(Left(SearchAndReplace([My String],"(Load ID)", "|") ,"|"))," ")------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Sign up

Login to the community