The Concatenate Formula

[Nickyb]

Hi,

I am trying to merge two cells of information using the Concatenate formula, but it doesn't seem to format in the way I want despite various attempts at formating the cells.

I have these two numbers in separate cells:

001 and 003

I want the result to be:

001003

I keep getting 13

Any ideas on how to solve this?

 

[al_b_cnu]

Hi nickyb,

Assuming the numbers are in A1 & B1, and they cant be > 999, try
=RIGHT(1000+A1,3)&RIGHT(1000+B1,3)
or alternatively
format the cells as Text & use
=A1&B1

 

[Ste_Moore01]

If, for example 001 is in A1 and 003 is in B1 use =A1&B1 in the cell you want it to appear in.

If you want to use the result as a number use =VALUE(A1&B1)


Hope that helps!