numeric+text to numeric

[aritra]

I wants a formulla which can easillly seprate numeric+text to numeric

like 1234aritra to 1234
1aritra to 1
1a to 1

in a single formulla

 

[Matt Rogers]

Hi.

Maybe like this?

Excel Workbook
	A	B
1	1234aritra	1234
2	1aritra	1
3	1a	1
Sheet

 

[Peter_SSs]

I wants a formulla which can easillly seprate numeric+text to numeric

like 1234aritra to 1234
1aritra to 1
1a to 1

in a single formulla

If the number is always at the start, try

=-LOOKUP(0, -LEFT(A1,ROW(INDIRECT("1:"&LEN(A1)))))

 

[Scott Huish]

If the number is always at the beginning, a very simple UDF will do it as well:

Function GetNumber(r As String) As Double
GetNumber = Val(r)
End Function

 

[aritra]

thnks a lot