Locate numbers in a row and send them to a cell

[bklim]

Dear Experts, below is the excel worksheet and i have problem locatin
the numbers because the numbers are not in the standard column, some i
B, some in C and D and the length of the numbers are not standard too
some 2, some 3 & 4 digits. If i want to send the numbers to specifi
column, let's say F, so that i can sort them later, is it possible?

Thank you in advance!

--A---B---C---D----E
XYZ DEF 98 STU VCD

QQQ 125 RTY VBN DRF

ABC DEF RFT 0980 RF

 

[Guest]

Hi

You could just use =SUM(A1:E1) which will ignore your text entries

Hope this helps.
Andy.

 

[Ardus Petus]

Following array formula will return 1st number in each row:
=INDEX(A1:E1,MATCH(TRUE,ISNUMBER(A1:E1),0))
Vamidate with Ctrl+Shift+Enter, not just Enter

HTH

 

[bklim]

Thanks alot, this is exactly what i want, expert

Regards