Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- bklim ------------------------------------------------------------------------ bklim's Profile: http://www.excelforum.com/member.php...o&userid=24268 View this thread: http://www.excelforum.com/showthread...hreadid=545028 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locate numbers in a row and send them to a cell
Hi
You could just use =SUM(A1:E1) which will ignore your text entries Hope this helps. Andy. "bklim" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locate numbers in a row and send them to a cell
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" a écrit dans le message de news: ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locate numbers in a row and send them to a cell
Thanks alot, this is exactly what i want, expert :) Regards -- bklim ------------------------------------------------------------------------ bklim's Profile: http://www.excelforum.com/member.php...o&userid=24268 View this thread: http://www.excelforum.com/showthread...hreadid=545028 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|