Converting Consumer Reports rating symbols to numbers
 

I have downloaded material from Consumer Reports and I am trying to convert
their 5 rating symbols to numbers. I have tried "if" statements and
"find"/"replace" but these approaches are looking for text data in the cell.
Do I need to do something with VBA?

Converting Consumer Reports rating symbols to numbers
 

If desired, send me your workbook to my address below along with desires and
before/after

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"LookingForCode" wrote in message
...
I have downloaded material from Consumer Reports and I am trying to convert
their 5 rating symbols to numbers. I have tried "if" statements and
"find"/"replace" but these approaches are looking for text data in the
cell.
Do I need to do something with VBA?