| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replacing characters
I have a sheet with old phone numbers on it. The numbers all have a leading
3 (ie 3476) which I want to replace with a 0 (ie 0476). Of course if I do a regular find and replace it will replace all 3's within the numbers not just the leading one. Can someone out there tell me what the best way to achieve this is. Thanks Graeme |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you make some characters in a cell bold and some not? | Excel Discussion (Misc queries) | |||
| vlookup first 4 characters only in a column | Excel Discussion (Misc queries) | |||
| Characters and Formulas | Excel Discussion (Misc queries) | |||
| how do i filter data by number of characters in excel? | Excel Discussion (Misc queries) | |||
| 255 characters in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
