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
(E-Mail Removed)
"LookingForCode" <(E-Mail Removed)> wrote in message
news:A278A11E-7906-485B-BF8E-(E-Mail Removed)...
>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?

Don,

I did send an email yesterday to (E-Mail Removed) with a copy of the
file. Actually our email account is (E-Mail Removed) 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
> (E-Mail Removed)
> "LookingForCode" <(E-Mail Removed)> wrote in message
> news:A278A11E-7906-485B-BF8E-(E-Mail Removed)...
> >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
(E-Mail Removed)
"David K" <(E-Mail Removed)> wrote in message
news:C490ECDF-F6CC-4AE0-B345-(E-Mail Removed)...
> Don,
>
> I did send an email yesterday to (E-Mail Removed) with a copy of
> the
> file. Actually our email account is (E-Mail Removed) 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
>> (E-Mail Removed)
>> "LookingForCode" <(E-Mail Removed)> wrote in
>> message
>> news:A278A11E-7906-485B-BF8E-(E-Mail Removed)...
>> >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
> (E-Mail Removed)
> "David K" <(E-Mail Removed)> wrote in message
> news:C490ECDF-F6CC-4AE0-B345-(E-Mail Removed)...
> > Don,
> >
> > I did send an email yesterday to (E-Mail Removed) with a copy of
> > the
> > file. Actually our email account is (E-Mail Removed) 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
> >> (E-Mail Removed)
> >> "LookingForCode" <(E-Mail Removed)> wrote in
> >> message
> >> news:A278A11E-7906-485B-BF8E-(E-Mail Removed)...
> >> >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?
> >>
> >>
>
>