How to find & replace all dates eg 3.19.2009 with 3-19-2009, ect?

  • Thread starter Thread starter fofficecommunityk
  • Start date Start date
F

fofficecommunityk

In my papers, dates are formatted as 3.19.08. I want to replace the periods
with dashes- all in one operation.
 
On the home tab, go to find
Type your date in the find box
add your new date to the replace box
click replace all
 
fofficecommunityk said:
In my papers, dates are formatted as 3.19.08. I want to replace the
periods with dashes- all in one operation.
Click to expand...

Use a wildcard search (http://www.gmayor.com/replace_using_wildcards.htm),
finding

([0-9]@).([0-9]@).([0-9]@)

and replacing it with

\1-\2-\3

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
That's almost too simple. Thanks, Jay!
And the link to gmayor helped me better understand how you figured that out,
and perhaps how I can figure out the next find and replace.

Jay Freedman said:
fofficecommunityk said:
In my papers, dates are formatted as 3.19.08. I want to replace the
periods with dashes- all in one operation.
Click to expand...

Use a wildcard search (http://www.gmayor.com/replace_using_wildcards.htm),
finding

([0-9]@).([0-9]@).([0-9]@)

and replacing it with

\1-\2-\3

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
Click to expand...
 
Back
Top