Hi
I have a list of numbers that vary in length and also contain the letter "x" in some of them like this:
0x60
1313
0x41
x254
123x
1
9x73
00x9
522x
335
x39x
34
And so on. I need to do 3 things:
1. Extract the last number only if it is a "1". If it is an "x", then I need to extract the second last number.
2. Extract the last number if it equals 1,2 or 3. If it is an "x", then I need to extract the second last number.
3. Extract the last number if there is an occurrence of 1 in the last 3. If there is only 1 or 2 numbers in the cell, then look for an occurrence of 1 in these and extract the last number.
Can anyone assist me with this please?
Thanks
Bookmarks