MrExcel Publishing
Your One Stop for Excel Tips & Solutions

concatenating a text cell with a currency cell

Posted by Nichelle Robinson on January 17, 2002 10:38 AM

I'm trying to combine two cells with different formats.
I would like to combine one cell with $1,000,000 and
ABC Company. With a return between the two
The end result needs to be:

ABC Company

within one cell without losing any of my formats.
Please help.

Posted by Dan on January 17, 2002 11:10 AM

If you concatenate a number cell with a text cell, the result is a text cell. A cell can have only one format.

You can certainly concatenate the two cells as you describe, but the cell will be recognized as a text string.

If A1="$1000.00" and B1="ABC Company", you can concatenate in C1 with formula:

=A1 & Char(10) & B1


Posted by Aladin Akyurek on January 17, 2002 12:41 PM

Dan --



not work? [ I don't see the effect of CHAR(10) on my Mac, whence my question. ]



Posted by Dan on January 18, 2002 6:10 AM

Yes, that is the correct way to write it.

Char(10) is the ANSI code for a hard break on PC's. I thought is was the same in Mac's as well. When I use the formula you gave below I get the desired hard break.

Posted by Aladin Akyurek on January 18, 2002 1:36 PM


Thanks for verifying it Dan. On the Mac: I dunno. Still not working. Even after a combination of CHAR(13) and CHAR(10), I need to check Wrap text to get the desired effect. Just weird.