Formatting Cells

[Guest]

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

 

[Guest]

Hi

If you use textformat on the firs column instead of "0000" then it works. I
wrote in the numbers in A like this: '0130. The little character before the
numbers give you "text"-formatting.

A (text) B
0130 MADA2582
0450 MADA2582
1041 MADA2582
2030 MADA2582

Then your recieve this: 0130 MADA2582

Hope it will work

Mia


"unouwanme" skrev:

 

[Rodrigo Ferreira]

RIGHT("0000" & A2, 4) & " " & B2