How do I extract numbers from many columns in excel on to one cel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
=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
 
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
Click to expand...

=SUMPRODUCT(A1:I1*10^{8,7,6,5,4,3,2,1,0})


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting just the time portion 5
Match and delete rows on two different sheets from reference numbers 4
Excel counts 2 digit numbers as 1... 5
How to separate text and numbers in one cell or column? 12
how do i filter records with greater number across rows 1
one cell in a row contains a number 7
How can I get assistance on Excel Formula? 2
Extraction 12

Back
Top