I have a column of data with values resembling this: HL7_Result_for_Message_ID_123Q324343.hl7 I need to grab that ID number (in bold), the challenge being that it can be any and all lengths. I have ...

How to Extract a Substring in Excel Using FIND() and MID() Functions Your email has been sent Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data.