View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

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?