the "0" number is lost when combining multiple columns

[Hal]

Hello,

I have data in two columns (A and B) that I wish to combine into a third
column (C) by using the "&" feature as follows:

=A1&B1

The data in Column A is a product code # (i.e. 05296)
The data in Column B are letters (i.e. MND)

However, when I combine them both together in Column "C", I get "5296MND"
instead of "05296MND". The "0" is missing. How I can maintain the
integrity of the "0" and have it appear in the cell?

Thank you in advance.

Hal.

 

[Max]

Try it in C1 as:
=TEXT(A1,"00000")&B1
where col A = prod codes

 

[SteveW]

This should work,
the problem is that the format of cell A1, is not used when you have
C1= A1 & B1

So you have to explicitly format A1 in the combine formula
Steve

 

[Hal]

Thank you Max for your help!

Hal

Try it in C1 as:
=TEXT(A1,"00000")&B1
where col A = prod codes

 

[Hal]

Thank you Steve for your help!

Hal.

This should work,
the problem is that the format of cell A1, is not used when you have
C1= A1 & B1

So you have to explicitly format A1 in the combine formula
Steve

 

[Max]

You're welcome, Hal !