Dear all,

I have a cell A1 which contains some text which is a concatenation of
texts in 2 cells (The formula is =CONCATENATE(A2, A3)). The texts in cells
A2 and A3 must be of length 5, so the text in A1 must be of length 10. If I
want the text in A1 is in 2 colours, i.e. the first 3 characters are red
while the remaining characters are in green, how can I set the format of the
cell A1?

Best Regards,
Sam