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:
$1,000,000
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
HTH
Posted by Aladin Akyurek on January 17, 2002 12:41 PM
Dan --
Does
=TEXT(A1,"$#,##0.00_);($#,##0.00)")&CHAR(10)&B1
not work? [ I don't see the effect of CHAR(10) on my Mac, whence my question. ]
Aladin
========
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
CHAR(10)
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.
Aladin
=======
