How to combine date and time columns into one column in Google sheets?
In Google sheets, you need to combine the date column and time column into one column as following screenshot shown, how could you deal with it in Google sheets?
To combine the date and time columns into one column, the following formula can help you:
1. Enter this formula: =concatenate(text(A2,"mm/dd/yyyy")&" "&text(B2,"hh:mm:ss")) into a blank cell where you want to put the combined result, then press Enter key to get the first combined cell.
2. And then select the formula cell and drag the fill handle down to the cells you want to combine, and the date and time columns have been combined into one column, see screenshot:
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 months agoApologies, I want to withdraw my previous comment. (I copied and pasted the formula, and I now realise that I can change the format.)
To post as a guest, your comment is unpublished.· 1 months agoThis does not work with Australian date formats. 12/10/2020 (27 Nov) when combined with the time will show 10/12/2020 (10 Dec).
To post as a guest, your comment is unpublished.· 1 years agoHello! I want to pull the column data into a cell (not row) separated by comma. And column contains all dates. Please provide the solution