View Single Post
  #3   Report Post  
CLR
 
Posts: n/a
Default

=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