Retain cell format while linking cells

J

Josh

I need some help here. I would like to link some cells together. Some
cells contain text, others contain currency. For Example:

A1 A2 A3
You owe me $10,000.00 Dollars!

I would like this to happen:

A5
You owe me $10,000.00 Dollars!


Linking cells doesn't work, I have read all over that it can be done
with VB. Except, there is no examples of what code would do this. I
would like help writing this simple (not for me) scenario, I could
make it work for what I need after that.

Thanks,
Josh
 
T

Tom Ogilvy

Think Frank meant:

In A5 put this formula:

=A1 & " " TEXT(A2,"$#,##0.00") & " " & A3
 
J

Josh

Frank Kabel said:
Thanks Tom for pointing this out (copy and paste error....)
Regards
Frank
Click to expand...

Thankyou, Thankyou!!! I was tricked there for a little, there was an
& missing from the formula.

here is what it is
=A1 & " " & TEXT(A2,"$#,##0.00") & " " & A3
You guys rock though! Thanks for replying so fast, I would have never
figured it out

Josh
 
Top