Hello all,

If I wanted to combine cell A1 "$10.00" with B1 "per day", how would I combine them so that the currency format would stay?

Currently I am using:

=CONCATENATE(A1," ",B1) but it is resulting in "10 per day". I'd like to keep the currency as well.

Thank you,
Scott