COMBINE TEXT AND TIME USING MICROSOFT EXCEL

This example shows how to combine text and time successfully.

To combine text and time:

1. Select cell A5 and type shutdown.
2. Select cell D5 and press <- Ctrl+Shift+: -> to insert the current time.
3. Select cell A7 and type the following formula: =" Today " & A5 & " at " & TEXT(D5,"hh:mm PM").

COMBINE TEXT AND TIME USING MICROSOFT EXCEL

Microsoft Excel Tutorials, 2007 Excel Tutorials, Combine Text and Time using Microsoft Excel, Microsoft Excel Video Tutorials, Formulas in Excel