keep $ formatting when concatenating

[Guest]

Here's a sample of my data:
A1: Building A
B1: $36,456.00
C1: =A1 & " " & B1

But C1 returns: Building A 36456

And what I want is this: Building A $36,456.00

In other words, the concatenation dumps the "currency" formatting in cell
B1, but I want to KEEP that formatting.

Can I do that?

 

[Guest]

Hi Danielo
Format B1 as text and type in your dollar amount manually.
HTH
Michael

 

[Peo Sjoblom]

Try

=A1&" "&TEXT(B1,"$#,##0.00")

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Guest]

That'd work, but not for what I'm doing. I'm pulling in B1 from anther
sheet, and need to NOT modify it.... Thanks for the suggestion, though!

 

[Gord Dibben]

danielo

=A1 & " " & TEXT(B1,"$#,##0.00")


Gord Dibben Excel MVP

 

[Guest]

OK
Well how about putting in an extra column, say D1, formatting as text and
using the formula =B1.
Hide that column and then put the formula in C1 =A1 & " " & "$" &D1
You can then copy down as far as needed.
This is probably a bit messy........but !!
HTH
Michael

 

[Guest]

Gord and Peo - THANK YOU! That works like a charm.