jaydee
08-05-2019, 04:39 PM
Hi,
I am trying to exact an 8 digit PO number out of the description field. The issue is, the person was not consistent in the past, leading to them putting the PO number in the beginning, middle, and end. Is it somehow possible to exact this from the field?
I attached a sample, column B has what I was trying to get out of column A.
Thank you for your time and consideration.
I am trying to exact an 8 digit PO number out of the description field. The issue is, the person was not consistent in the past, leading to them putting the PO number in the beginning, middle, and end. Is it somehow possible to exact this from the field?
I attached a sample, column B has what I was trying to get out of column A.
Thank you for your time and consideration.