Thread: How do I extract numbers from many columns in excel on to one cel.
View Single Post
  #4   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default
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 With QuoteReply With Quote