U
unouwanme
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
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