| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Values to Something Else
I need a macro that looks for certain values on a sheet and changes them, for
example: Change 1 to 1 Change 2 to 2 Change 11/2 to 1-1/2 Change 15/16 to 1-5/16 Change 113/16 to 1-13/16 Each of those values are in their own cell. There are some cells that have phrases such as: 2 Pieces I dont want that to get changed to 2 Pieces Thank you, Jeff Jensen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How does one auto-change values? | Excel Worksheet Functions | |||
| Lookup and Change Values | Excel Worksheet Functions | |||
| Conditional formatting does not change when values change. ?? | Excel Worksheet Functions | |||
| How do I change a range of values from + to -? | Excel Discussion (Misc queries) | |||
| change values globally | Excel Worksheet Functions | |||
Threaded Mode
