I need to extract substrings (measurements) from thousands of product descriptions. I am pretty sure this cannot be done using a formula, hence, I guess I require a macro solution.
As you can see from the screenshot, the measurements to be extracted have four possible formats. The trouble is that there are cases where there is no space or comma in front of or behind these measurement substrings.This is the case in the first and the third example.
I hope somebody will be able to come up with some macro solution for my problem.
Help is very much appreciated. Thank you very much in advance.
I have attached the above sample file for your convenience.