This week's MS Office challenge tests your knowledge of Word and shares the answer to last week's interesting challenge on Excel date strings.
Conventions sometimes require you to enter specific information about a document in the document itself. For instance, you might need to display the file's name, the document's creation date, the number of words in the document, and so on. You can spend a lot of time entering that data manually and then updating it as needed. However, it seems like something Word should do for you. Can you get Word to insert information about the document in the document?
Last week we asked…
How would you convert date strings to valid date values in Excel? You provided several interesting solutions, but Tiegsj provided the answer I was looking for:
Thanks to everyone for some great solutions!
- Highlight the column.
- Choose Text To Columns from the Data menu.
- When Excel opens the Text To Columns wizard, click Finish.
