combine cells and maintain significant digits

I

Ian

I'm trying to join 3 cells that are map references
A1 35
B1 02
C1 105

When I join the with A1&B1&C1 I get 352105 when I need 3502105. How do I
maintain the significant digits to the left without changing the cells to
text format? (I'd like to maintain them as numbers for other reasons).

Thanks.
 
R

Ron Rosenfeld

I'm trying to join 3 cells that are map references
A1 35
B1 02
C1 105

When I join the with A1&B1&C1 I get 352105 when I need 3502105. How do I
maintain the significant digits to the left without changing the cells to
text format? (I'd like to maintain them as numbers for other reasons).

Thanks.
Click to expand...


=TEXT(A1,"00")&TEXT(B1,"00")&TEXT(C1,"000")


--ron
 
R

Ron Rosenfeld

Thanks, Chuck.

By the way, if you've got Longre's morefunc add-in, you can simplify a bit by
using the **array** formula:

=MCONCAT(TEXT(A1:C1,{"00","00","000"}))

(I'm not sure if it's more or less efficient, probably less <g>).

Unfortunately, Excel's CONCATENATE function won't concatenate a range nor an
array.

--ron

Nice one Ron...........

Vaya con Dios,
Chuck, CABGx3
Click to expand...

--ron
 
Top