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?

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?

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?

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?

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?

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

"LookingForCode" wrote:

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?

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.

"Mike H" wrote:

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

"LookingForCode" wrote:

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?