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: ([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.