COMBINE TEXT AND DATE USING MICROSOFT EXCEL

Excel has a problem combining cells that contain text and dates. This results in the date showing up as a number value because Excel has lost the format. To get the desired result, use the following workaround.

To combine text and date:

1. Select cell A1 and type actual status.
2. Select cell D1 and type the following formula: =TODAY().
3. Select cell A3 and type the following formula: =A1& " " &TEXT(D1,"MM/DD/YYYY").

COMBINE TEXT AND DATE USING MICROSOFT EXCEL

Microsoft Excel Tutorials, Combine Text and Date using Microsoft Excel, Date Function, Microsoft Excel Video Tutorials, Advanced Excel Tutorials