Thread: Converting Consumer Reports rating symbols to numbers
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
David K[_2_] David K[_2_] is offline
external usenet poster
  
Posts: 3
Default Converting Consumer Reports rating symbols to numbers
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?


Reply With QuoteReply With Quote