Lets assume I have a random letter in in the following cells; A1, A2 & A3. In cell A4 I have a type of animal. In cell B1 I simply have "=concatenate(A1,A2,A3,A4)".
1 X XZVCat
What I would like to do is have each part of the data in the cell B1 colour coded. I.e. First letter Blue, second letter yellow, third letter green with the type of animal being black.
Is there anyway to achieve such an idea?
Many thanks, Alan.