How to set different font colours in a cell?

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

See one response at your post in .excel.

Sam wrote:
>
> 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

--

Dave Peterson