Extract only the numbers

[gpapagre]

Dear all,

thanks for your hospitality. this is the second time i post a question to this board, hopefully i will get the same help as in the first time when NMeeker solved my problem with missing invoices. i thank him very much.

my question is simple.

In column A I have a list of numbers which unfortunalely sometimes when I extract them from accounting softwares are in the form of letters, commas etc plus the numbers. examples: INVOICE_5526, INV-2343, INV/3369 and in other formats. What I want to have in column B is just the numbers.

Is there a formula I can apply in any case to isolate only the numbers?

Thank you all
George

 

[gpapagre]

There must be happening something. Are you seeing the formula instead of a result?

Yes. I see the formula, just that. No only with this formula but with any other.

When press F2 and Enter (just to see) a message also appears "the formula you typed contains an error. for info about fixing common formula problems..."

 

[Aladin Akyurek]

Yes. I see the formula, just that. No only with this formula but with any other.

When press F2 and Enter (just to see) a message also appears "the formula you typed contains an error. for info about fixing common formula problems..."

Lets try a few things:

Enter the following in K1:K10...

0
1
2
3
4
5
6
7
8
9

Go the Formula Bar, type =, then select K1:K10, hit F9, and copy what you see and paste here in your reply.

 

[gpapagre]

Lets try a few things:

Enter the following in K1:K10...

0
1
2
3
4
5
6
7
8
9

Go the Formula Bar, type =, then select K1:K10, hit F9, and copy what you see and paste here in your reply.

Thanks again, I did exactly as you said. For sure I must be doing something wrong. I did as you say and here are the results.
{0;1;2;3;4;5;6;7;8;9}

 

[Aladin Akyurek]

Thanks again, I did exactly as you said. For sure I must be doing something wrong. I did as you say and here are the results.
{0;1;2;3;4;5;6;7;8;9}

Perfect. Now re-try:

=REPLACE(A2;1;MIN(FIND({0;1;2;3;4;5;6;7;8;9};A2&"0123456789"))-1;"")+0

 

[gpapagre]

perfect. Now re-try:

=replace(a2;1;min(find({0;1;2;3;4;5;6;7;8;9};a2&"0123456789"))-1;"")+0

thank you very much!
I wish you all the best! Sending you now my best wishes...