Converting Consumer Reports rating symbols to numbers

[LookingForCode]

I have downloaded Consumer Reports ratings symbols (5 symbols from Excellent
to Poor) and I would like to convert symbols to numbers. Tried "if"
statements but this does not recognize the "symbol" in the cell. Is there a
way to do this in VBA?

 

[Don Guillett]

In the absence of seeing your workbook as requested, have a look in the help
index for VLOOKUP

 

[Mike H]

Hi,

I Googled for these symbols so i could try and find a solution but no joy
where do I get them, what are they?

Mike

 

[David K]

I can't seem to paste the symbols here. I did send an email to Dan Guillett
who was looking into it also. I haven't heard back from him yet. I would be
happy to send an email to you with the symbols too. If you are will
interested (which I would appreciate), please let me know your email address.

 

[David K]

Don,

I did send an email yesterday to [email protected] with a copy of the
file. Actually our email account is [email protected] but my wife name shows
up (Elayne Kremer). I will look into the vlookup approach.

Thanks.

 

[Don Guillett]

I can't seem to find a way to identify the various shapes. Perhaps Jon
Peltier can help.
http://peltiertech.com/Excel/Charts/index.html

 

[David K]

Thanks very much for looking into it. I have sent an email to Jon.