keep $ formatting when concatenating

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Try

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

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
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!
 
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
 
Back
Top