0

Basically I have a column showing poker hands data in the following form:

AsKh TcTd QsQh 5d7d

I want to apply a conditional formatting formulat to the column so that diamonds 'd' gets replaced with a blue diamond symbold and their preceding card gets colored blue. And so forth with all cards. The goal is to make it easier to read the data.

Thanks a lot!

user2851097
  • 3
  • 1
  • 1
    You'll probably want to use some sort of macro to split the formatting with the cell between symbol and regular font, with a substitute function to turn c, h, d... into char(167), char(168), ... – nutsch Oct 18 '13 at 22:56
  • Yeah I could definetely split the column into more. Why are you suggesting four columns? Letter | Suit | Letter | Suit ? – user2851097 Oct 19 '13 at 01:33

1 Answers1

0

You can use the following formula in a cell formatted with the symbol font. J and Q will look funky though. You'll have to use a macro to address that and basically adjust the font for each cell of the result.

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"c",CHAR(167)),"h",CHAR(169)),"s",CHAR(170)),"d",CHAR(168))
nutsch
  • 5,922
  • 2
  • 20
  • 35