Find and Replace

  • Thread starter Muhammad Hassan (New Excel User)
  • Start date
M

Muhammad Hassan (New Excel User)

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.
 
C

CLR

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
User)@discussions.microsoft.com> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing a repeated words 0
Using Flags with Resource Percentages 0
Word macro that can call cells out of Excel for a find and replace 0
How to correct a #N/A in vlookup 1
Find/Replace specific indent 1
Drop down list control value in vba 2
Can't seem to delete all images from a Word Doc 2
Word- Find and Replace 1

Top