Extract a number out of a string

**Limor_OP** · 10-07-2021, 02:18 PM

Hello,
how can i extract only the number in the attached?

Thanks.

**Sam Capricci** · 10-07-2021, 02:25 PM

This would work for you, I found this one a long time ago but it pulls the numbers out of a string. It is a little convoluted.

=IFERROR(LOOKUP(9E+99+307,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&1234567890)),ROW(INDIRECT("1:"&LEN(A1))))),"")

**Limor_OP** · 10-07-2021, 02:27 PM

Amazing.
I dont know how but it works perfectly. Thank you!!

**FlameRetired** · 10-07-2021, 02:27 PM

If they all have the same format of number leading strings try this.

Formula:

Please Login or Register  to view this content.

**Limor_OP** · 10-07-2021, 02:30 PM

The second is fantastic as well, thank you so much for the quick solution!

**Sam Capricci** · 10-07-2021, 02:31 PM

You’re welcome, AND thank you for the rep!

**Bo_Ry** · 10-07-2021, 02:46 PM

Please try

Number as Number
=--LEFT(A1,FIND(" ",A1))

Number as Text
=LEFT(A1,FIND(" ",A1)-1)

**Limor_OP** · 10-07-2021, 03:13 PM

Thanks BO_RY!
so simple yet I havent thought of that....

Extract a number out of a string

LinkBack

Thread Tools

Rate This Thread

Display

Extract a number out of a string

Re: Extract a number out of a string

Re: Extract a number out of a string

Re: Extract a number out of a string

Re: Extract a number out of a string

Re: Extract a number out of a string

Re: Extract a number out of a string

Re: Extract a number out of a string

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extract first number in a string, and the three letters after the first number

[SOLVED] Extract certain number from string

Extract number from string

[SOLVED] How to Extract A Number from String if Text within the String Equals XYZ

[SOLVED] Extract a mainly numeric string (ISSN number) from an arbitrary string

[SOLVED] How to extract Fist number, Last number from string and SUM

[SOLVED] Extract number from text/number string..

Bookmarks

Bookmarks

Posting Permissions