Hey,

So i have a lot of lists like this
J♠2♥
9♠5♥
T♠6♥
9♠7♥
Q♣6♠


I want to change them to
J♠2♥
9♠5♥
T♠6♥
9♠7♥
Q♣6♠

I know i can go find and replace and format the cell but that changes the colour of the whole cell. Is there a way to just chnage the colour of one character? I have googled it for a while and people have been mentioning macros etc? I'm not good with them so was looking for some help.

Thanks,

lewgill