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
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
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}))
You could use a UDF like this
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
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".
UDF
Please Login or Register to view this content.
Or try:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks