hi,
this can be done with hard characters but not with a formula.

regards
FSt1

"bookman3" wrote:

If I have a cell which is either concatenated or uses & between clauses, is
it possible to have the differeent element in differencolours. Or is there
anothe way of achieving this?

eg =concatenae("today is", H3) where H3 is a cell reference that I want
in a different colour from today is.

Regards
--
bookman