Extract data from a long text field
How can I get the number 12 from this field AIR WICK AIR FRESHENER 12/8 oz SNUGGLE FRESH LINEN https://www.screencast.com/t/1w1uGCphWs
Forum Discussion
Is this doable?
I need it badly
I need it badly
Ha ha - This old post may be of help:
https://www.mrexcel.com/forum/excel-questions/1057397-how-extract-specific-data-cell-3.html
There isn't enough of a pattern demonstrated from one field value to come up with a reliable parsing strategy. The string you entered could just be someone's random narrative description.
https://www.mrexcel.com/forum/excel-questions/1057397-how-extract-specific-data-cell-3.html
There isn't enough of a pattern demonstrated from one field value to come up with a reliable parsing strategy. The string you entered could just be someone's random narrative description.