I'm trying to figure out how to combine many cells into one cell in a Google Sheet. The target cells contain many different types of data (date, time, text, numbers, etc.) and I need to merge them into one cell so they appear as displayed in the target cells.
I need to be able to combine the following into one cell.
Col A Col B Col C Col D Col E text date time text time
I can use
=A1&B1&C1&D1&E1, but it only works with text. When it gets to date or time data, it displays random numbers instead of a date or time.
Is there a method for copying the data in the cells (the way it is displayed) and merging it into one?