adding card suits symbols to replace text

[NIKOG]

Hello i am really noob please help me step by step? im trying to replace automatically in a text in excell letters to card suit symbols(need them to be in proper suits colors also) for example -'S" to turn into - black spades ,
"H" turns red heart symbol , "c" - green club symbol , D into blue diamond symbol , - im gonna post a screenshot how i want to make them so u guys have a clear idea :
Gyazo . At the moment my tex looks like this for example the first 1 from the screen shot : Ah 6d 5c
Thanks in front for u time

 

[Joe4]

Duplicate to: s there a way to replace specific letters in a range of cells with symbols?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.