F
fofficecommunityk
In my papers, dates are formatted as 3.19.08. I want to replace the periods
with dashes- all in one operation.
with dashes- all in one operation.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to find & replace all dates eg 3.19.2009 with 3-19-2009, ect?
B
Bojingles03
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
Type your date in the find box
add your new date to the replace box
click replace all
J
Jay Freedman
fofficecommunityk said:In my papers, dates are formatted as 3.19.08. I want to replace the
periods with dashes- all in one operation.
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.
F
fofficecommunityk
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.
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.
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.