Need a SPECIFIC type of number to be extracted from 2 columns and placed into 1
Co-worker needs help cleaning up some data (that they get once a month so not a one-off) where he naturally wants all of the PO Numbers to go into the PO Number column he added.
The issue is whoever is originally putting this data together puts the PO numbers in one of two columns (or as often, not at all) so I want to help him write a formula/macro/script that will extract the PO numbers from these 2 columns and combine them into one.
Sounds simple enough but the problem is I ONLY want it to extract PO numbers, which are the ones that begin 01001- and to leave everything else. And as you can see they show up in either column along with a bunch of numbers no one cares about. Is there an easy way to accomplish this that I am missing? Thanks in advance
[link] [comments]
Want to read more?
Check out the full article on the original site