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

"Don Guillett" wrote:


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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"David K" wrote in message
...
Don,

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

Thanks.

"Don Guillett" wrote:

In the absence of seeing your workbook as requested, have a look in the
help
index for VLOOKUP
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"LookingForCode" wrote in
message
...
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?