| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compute a rating of a mtd average compared to a rating scale | Excel Discussion (Misc queries) | |||
| Symbols instead of numbers | Excel Discussion (Misc queries) | |||
| How do I select colors instead of numbers for rating risk? | Excel Worksheet Functions | |||
| Excel as an OLE DB consumer | Excel Programming | |||
| removing symbols from numbers | Excel Programming | |||
Linear Mode
