Concatenate Cell with a custom number format

  • Thread starter Thread starter Donna
  • Start date Start date
D

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
 
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
 
Back
Top