If you want to CONCATENATE say A1 and B1, put a space and an Alt-Return in a
helper cell, say C1, then
=A1&C1&B1 will give you your second line in the target cell...........
If you want the BOLD, the only thing I know to do is to set the whole target
cell to BOLD.
Vaya con Dios,
Chuck, CABGx3
"rivgrl85" wrote in message
...
I am concatentating a group of Excel cells. The first cell has bold font
and
when I concatenate it, the bold disappears. Also, need to put a return in
the formula to get second cell to go to next line. Can anyone help me?
|