Concatenate Formating

[Bob]

I am running into a promblem when I use concatenate. Specifically, I
am trying to bring together the following cells:

A1 - Contains "N="
B1 - Contains "1,457"

The Formula =CONCATENATE(A1,B1) Results in N=1457

Is there anyway I can retain the formatting of Cell B1. I need the
result to include the comma (N=1,457)

Thanks in advance

 

[ianripping]

Try using
C1:

=a1&b1

this should retain the values

 

[Frank Kabel]

Hi
try
=A1 & TEXT(B1,"0,0")

 

[DDM]

Bob, two possibilities:

1- =CONCATENATE(A1,TEXT(B1,"#,###"))
2- =A1&TEXT(B1,"#,###")

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[Bill Allen]

Try:
=A1&text(B1,"#,###")

Regards,

Bill Allen