| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replace one set of numbers with another
I want to be able to put in the code and it replace it with a phone number.
Is there any way to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
replace one set of numbers with another
bequa
You can use Tools Autocorrect to do that through the UI. If you want to do it in VBA, you would use the Worksheet_Change event. Post back if you need more information. -- Dick Kusleika MS MVP - Excel www.dailydoseofexcel.com bequa wrote: I want to be able to put in the code and it replace it with a phone number. Is there any way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace numbers with time | Excel Discussion (Misc queries) | |||
| replace numbers with X | Excel Discussion (Misc queries) | |||
| How to Replace Numbers with Phrases | Excel Discussion (Misc queries) | |||
| How to Replace Numbers with Phrases | Excel Discussion (Misc queries) | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Hybrid Mode
