text color

  • Thread starter Thread starter layla
  • Start date Start date
L

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!
 
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.
 
Back
Top