A formula can only return a value to a cell, so you cannot return formatting
and such.

=A1&A2 will return the value of A1 and A2 to the cell that has that formula
entered in it.

HTH
Regards,
Howard

"CraigS" wrote in message
...
I'm using "&" to combine data from multiple cells. Each cell has text of
a
different color and I want to preserve those colors in the new combined
cell.
The new combined cell is formatting all the text to one color.

Anyone have any suggestions on how to maintain the separate colors in the
new cell?