When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.

The date will display in the format you choose, no matter how you enter it. If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date.

Microsoft is testing out a new =COPILOT function in Excel cells – it's in beta with improvements needed, but you can try it ...