Formula help
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 bet...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis might work
Right(
Trim(Left(
SearchAndReplace([My String],"(Load ID)", "|") ,"|"))," ")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Right(
Trim(Left(
SearchAndReplace([My String],"(Load ID)", "|") ,"|"))," ")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------