Transpose dates from mm/dd/yy to yy/mm/dd

Example: from 12/17/85 to 85/12/17

Article contributed by Bill Coan

Use Word's wildcard Find & Replace capabilities.

1.

Click More... in the Replace dialog box and check Use Wildcards.

2.

Enter the following values into the dialog:
Find What:

([0-9]{1,2})/([0-9]{1,2})/([0-9]{1,2})

Replace With:

\3/\1/\2

3.

Place an X in the Use Wildcards box.

4.

Click Replace All.

For many more examples of wildcard searches, including more date examples; and for in-depth coverage of how to use wildcards, see: Finding and replacing characters using wildcards.


Click to view Terms of Use page

Click to view Disclaimer page