View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LookingForCode LookingForCode is offline
external usenet poster
 
Posts: 2
Default 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?