Locate numbers in a row and send them to a cell

Dear Experts, below is the excel worksheet and i have problem locating the numbers because the numbers are not in the standard column, some in 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 specific 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 RFG

Hi

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

Hope this helps.
Andy.

"bklim" <bklim.28b7fn_1148469902.2833@excelforum-nospam.com> wrote in
message news:bklim.28b7fn_1148469902.2833@excelforum-nospam.com...
>
> Dear Experts, below is the excel worksheet and i have problem locating
> the numbers because the numbers are not in the standard column, some in
> 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 specific
> 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 RFG
>
>
> --
> bklim
> ------------------------------------------------------------------------
> bklim's Profile:
> http://www.excelforum.com/member.php...o&userid=24268
> View this thread: http://www.excelforum.com/showthread...hreadid=545028
>

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
--
AP

"bklim" <bklim.28b7fn_1148469902.2833@excelforum-nospam.com> a écrit dans le
message de news: bklim.28b7fn_1148469902.2833@excelforum-nospam.com...
>
> Dear Experts, below is the excel worksheet and i have problem locating
> the numbers because the numbers are not in the standard column, some in
> 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 specific
> 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 RFG
>
>
> --
> bklim
> ------------------------------------------------------------------------
> bklim's Profile:
> http://www.excelforum.com/member.php...o&userid=24268
> View this thread: http://www.excelforum.com/showthread...hreadid=545028
>