Hello
Where there is an entry in Cell A3 like "10th to 14th Floors" I am using the formula below to return the first numeric value from A3, in this case "10"
=LOOKUP(50,--("0"&MID(A3,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A3&"0 123456789")),ROW($1:$10))))
This works just fine, but I have been trying to adapt it to find the second numeric value, which in this example would return "14". I have tried using the character number for the first numeric value as the start number in searches, but can't quite make it work!
Any suggestions on how to would be welcome - or a new approach (VBA?) for finding the second numeric value in a string.
Obviously, as shown in the formula, the numbers I am searching for are not always single digit numbers.
Thanks in advance for any help you can offer
Dave
Where there is an entry in Cell A3 like "10th to 14th Floors" I am using the formula below to return the first numeric value from A3, in this case "10"
=LOOKUP(50,--("0"&MID(A3,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A3&"0 123456789")),ROW($1:$10))))
This works just fine, but I have been trying to adapt it to find the second numeric value, which in this example would return "14". I have tried using the character number for the first numeric value as the start number in searches, but can't quite make it work!
Any suggestions on how to would be welcome - or a new approach (VBA?) for finding the second numeric value in a string.
Obviously, as shown in the formula, the numbers I am searching for are not always single digit numbers.
Thanks in advance for any help you can offer
Dave