Concatenate Numers / Text (Special)
 

- I need to concatenate three cells each containing specific info:
1st cell is a letter (ie. "A", "B", etc.)
2nd & 3rd Cells are two digit numbers (ie. 01, 02....10,11)-(format is
custom 00)

I need the combination to concatenate and show as follows:

A0105, B1106, H0209, etc.

Please help, I am beginning to think that this is an impossible task.

Concatenate Numers / Text (Special)
 

=a1&text(b1,"00")&text(c1,"00")

or you could do the arithmetic first:

=a1&text((b1*100)+c1,"0000")


Teddy-B wrote:

- I need to concatenate three cells each containing specific info:
1st cell is a letter (ie. "A", "B", etc.)
2nd & 3rd Cells are two digit numbers (ie. 01, 02....10,11)-(format is
custom 00)

I need the combination to concatenate and show as follows:

A0105, B1106, H0209, etc.

Please help, I am beginning to think that this is an impossible task.

--

Dave Peterson

Concatenate Numers / Text (Special)
 

try this

assumed cell A1 has Letter
B1 & B2 has numbers

=A1&TEXT(B1,"00")&TEXT(B2,"00")




On Dec 24, 9:30*pm, Teddy-B wrote:
- I need to concatenate three cells each containing specific info:
1st cell is a letter (ie. "A", "B", etc.)
2nd & 3rd Cells are two digit numbers (ie. 01, 02....10,11)-(format is
custom 00)

I need the combination to concatenate and show as follows:

A0105, B1106, H0209, etc.

Please help, I am beginning to think that this is an impossible task.