How to Concatenate Date and Text in Excel
June 10, 2022
Very often we need to concatenate date and text in Excel. However, this is not as intuitive as you may think. If you simply use the CONCATENATE function, you may end up having something like “44690”. This is because the way Excel see dates is different from how we see dates.
Categories
.
- Array Formula (3)
- Data validation (3)
- Excel Formula & Functions (34)
- Excel Skills (37)
- Excel Tips and Tricks (38)
- Finance (5)
- Formatting (8)
- Option Pricing (3)
- Pivot table (3)
- Sharing (8)
- Shortcuts (13)
- Solver (1)
- Technical (6)
- VBA (18)