Only first numbers extract

[sohaila]

Hi,

can any one help me i want to extract only first numbers in string like
"new trick#14- fhf 34" to extract only 14 and
"dfr new trick 1 fdff 7 df 787" to 1
"dff -trt# 77 df 4 " to 77

Is this possible?

thanks

[Phuocam]

Try this:

=LOOKUP(10^17,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"1234567890")),{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16}))

[mikerickson]

You could use a UDF like this

Please Login or Register  to view this content.

[David A Coop]

I found this on another forum.

=MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),2)+0 - this will work provided the first number found is 1 or 2 digits.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[Phuocam]

UDF

Please Login or Register  to view this content.

[Phuocam]

Or try:

Please Login or Register  to view this content.