Combine Text and Date - Formulas In Excel - Microsoft Excel Tutorials

14.  Combine text and date

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").

Watch the Video Tutorial - https://www.youtube.com/watch?v=h4G5sb_paLU

  Hope You Like This Tutorial - Give Comments