I have a formula which copies the text in cell A2 into B2. The text is typed
in A2 in two different colours but when it is copied into B2 it shows in one
colour. Is it possible for it to show it in the same colours or is it
possible for me to have a function that locates a character and changes the
colour of that character only and not the remaining characters in the cell