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

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:

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

=A2&" "&B2

Try instead in C2:
=TEXT(A2,"0000")&" "&B2
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"unouwanme" wrote:
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

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

--

Rodrigo Ferreira


"unouwanme" escreveu na mensagem
...
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