| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find and Replace
Hello, I am facing a problem regarding finding and replacing, i want to
change a value ":10:20" to "00:10:20". Or in other words just want to add a leading zero before the colon. I have used the wild card to locate the value but in replce it chages the value with wild card. Please Help me in this. |
|
#2
|
|||
|
|||
|
Find Replace Repl;ace what: :1 Replace with: '00:1 Replace all
Vaya con Dios, Chuck, CABGx3 "Muhammad Hassan (New Excel User)" <Muhammad Hassan (New Excel wrote in message ... Hello, I am facing a problem regarding finding and replacing, i want to change a value ":10:20" to "00:10:20". Or in other words just want to add a leading zero before the colon. I have used the wild card to locate the value but in replce it chages the value with wild card. Please Help me in this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and REPLACE within a selection, or column- not entire sheet/. | Excel Worksheet Functions | |||
| Find and replace data in an Excel chart object | Charts and Charting in Excel | |||
| Find and Replace - Quickest Option? | Excel Worksheet Functions | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Linear Mode
