Hi,

I have a w/sheet where Column A contains a 4 digit number and Column B An 8
Alphanumeric figure. e.g. below:

A B
0130 MADA2582
0450 MADA2582
1041 MADA2582
2030 MADA2582

The format cells for Column A is set to Custom 0000 so that the 0 is visible.

I want to enter in column C the formula:
=A2&" "&B2

So the figure i want looks like:
0130 MADA2582

BUT, when i do this it changed the figure to:
130MADA2582

How would i go about changing this? so that i can get the figure 0130
MADA2582???

As i need the figure to run a lookup and when i run the look up on 130
MADA2582, it does not pick up the 0130 MADA2582 codes.

Your help would be greatly appreciated

Ryan