So, I am trying to extract numbers from a Measurements column for product that we sell. I want to extract all numbers from the Left up until text starts and I want to extract all numbers from Right until text starts.
I started with the following Formulas as follows:
=LEFT(T2,LEN(T2)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},T2&"0123456789"))-1)
&
=RIGHT(T2,LEN(T2)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},T2&"0123456789"))-1)
However, those formulas work for some fields & not for others. I have attached the file I have been working on.
Any help would be greatly appreciated.
Bookmarks