View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

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.