Hi There,
I need to extract order numbers from a cell that contains a large text string, like in cell A1 containing “AP13215hsgyh),AP13333,)218)gsjebbjAP13376/()827)?AP13222……” AP+5 digits are all orders that I need to extract from this cell, which may contain 20 orders at a time.
Any thought?
Thanks ahead
I need to extract order numbers from a cell that contains a large text string, like in cell A1 containing “AP13215hsgyh),AP13333,)218)gsjebbjAP13376/()827)?AP13222……” AP+5 digits are all orders that I need to extract from this cell, which may contain 20 orders at a time.
Any thought?
Thanks ahead