Concatenate Cell with a custom number format

[Donna]

Hi,

I'm trying to concatenate the following:

Column A Column B Column C
(Entered) (Displayed)
[custom format '00####']
BNY 3415 003415 BNY3415

I need for Column C to be "BNY003415". Any ideas? I've
tried to copy column B and paste special, values, but it
still returns the same result. HELP!

Thank you so much!
Donna

 

[RagDyer]

Try this in C1:

=A1&TEXT(B1,"00####")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi,

I'm trying to concatenate the following:

Column A Column B Column C
(Entered) (Displayed)
[custom format '00####']
BNY 3415 003415 BNY3415

I need for Column C to be "BNY003415". Any ideas? I've
tried to copy column B and paste special, values, but it
still returns the same result. HELP!

Thank you so much!
Donna

 

[Max]

Try in C2: =A2&TEXT(B2,"00####")

 

[Donna]

That worked! Thank you both!

 

[Max]

Glad to hear that, Donna !
You're welcome ..