| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I extract numbers from many columns in excel on to one cel.
I have a worksheet with 9 columns, each column contains 1 number, on column
10 I want to see the 9 digits as one single number |
|
#2
|
|||
|
|||
|
As Text
=A1&B1&C1&D1&E1&F1&G1&H1&I1 As Number =--(A1&B1&C1&D1&E1&F1&G1&H1&I1) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "DFALUSA" wrote in message ... I have a worksheet with 9 columns, each column contains 1 number, on column 10 I want to see the 9 digits as one single number |
|
#3
|
|||
|
|||
|
=CONCATENATE(A1,B1,C1,D1,E1,F1,G1,H1,I1)
OR =CONCATENATE(A1,B1,C1,D1,E1,F1,G1,H1,I1)*1 Vaya con Dios, Chuck, CABGx3 "DFALUSA" wrote in message ... I have a worksheet with 9 columns, each column contains 1 number, on column 10 I want to see the 9 digits as one single number |
|
#4
|
|||
|
|||
|
On Wed, 2 Mar 2005 15:15:02 -0800, "DFALUSA"
wrote: I have a worksheet with 9 columns, each column contains 1 number, on column 10 I want to see the 9 digits as one single number =SUMPRODUCT(A1:I1*10^{8,7,6,5,4,3,2,1,0}) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract numbers, convert to date | Excel Discussion (Misc queries) | |||
| Sum of all even and odd numbers between two columns | New Users to Excel | |||
| How to sort random numbers in columns | Excel Discussion (Misc queries) | |||
| How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
| How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
Linear Mode
