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

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

=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

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