I need to know a way to extract a number from a text in excel. For example, if i have ABC123, I only need 123?

Question

Obviously, I looking for a function to do that, because I need to use the value in some other place.

Obviously, I'm looking for a function to do that, because I need to use the value in some other place.

Answer 1

The function you want is the ISNUMBER() function. Check the string one character at a time and write only the numbers to the result.

strTest = "ABC123"
strResult = ""

for x = 1 to len(strTest)
chrTest = mid(strTest(x,1))
If ISNUMBER( chrTest ) Then
strResult = strResult & chrTest
End If

Answer 2

Double click the form field, highlight the ABC and press "delete" on your keyboard. Not sure if that is what you wanted to do or not.

Answer 3

with ABC123 written in cell A1 and formula in B1 the formula would be =RIGHT(A1,3)