How do I preserve text color when combining cell data

[CraigS]

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?

 

[L. Howard Kittle]

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

 

[FSt1]

hi
since you are using an ampersand (&), i am assuming that you are using a
formula.
where as it is possible to have multiply font formats in a single cell, this
applies to text only. it does not apply to numbers or formulas. this is
because xl needs specific start and stop points in order to have the multiple
formats. if you convert your formula to hard text, you can reformat to have
the desired formats. just high light the protion of the text in the formula
bar that you want one color and right click the formula bar. from the pop up,
select format cells. you may notice that not all format features are
available. once you may your selection and ok out, select the other portion
of text and repeat.
yeah i know. big hassel. but,,,, that is the way MS set it up.

regards
FSt1

 

[CraigS]

In the formula =A1&A2 is there any way to highlight A1 and set a font color,
select A2 and set a different color?