I am needing to pull numbers from the middle of a cell. The problem is that the data is entered by many different people and none of them do it the same way. One cell could have “W/.5LWOP/2.75LS” another cell “N 2.5 LS 1.75 LC” another “N 5LS” yet another “N 4@99 1.5LC 2LS 2LU”. Some use spaces between other use "/" and some use a space. The numbers I need are preceding the LS in each cell (including the “.” If there is one)
I have been told to use RegEx in VBA, however i have little experience with VBA and no experience with RegEx.
I have been working on this for weeks any help would be greatly appreciated.
I have been told to use RegEx in VBA, however i have little experience with VBA and no experience with RegEx.
I have been working on this for weeks any help would be greatly appreciated.