text color

[layla]

Hi,
my goal is to connect more than 3 strings together in a rectangular
cell.Then be able to access any of these string and color them.
Q1) can I concanetate the strings in one cell( as range) one on top of
the other
Q2)How can I color each them, if all I know is the range's name
Thanks!

 

[Shane Devenshire]

Hi,

I assume by string you mean text. You can concatenate using the CONCATENATE
function or better yet the concatenation operator &

=A1&A2&A3

However, since this is a formula you really can't format a piece of it. If
on the other hand you don't need the formula you can convert the formulas to
values and then highlight any part of the results and format that portion.