How To Combine Data From Three Cells ?



1. Click on the cell where you would like the new data to start. Here, this is cell G2.

2. Enter the CONCAT command as =CONCATENATE(C2," ",D2,", ",E2)


Pay particular attention to the extra strings you added between the month and the day, and between the day and the year. This is how you get the spaces and comma in your final result.


3. Fill out the rest of the column using the same click-and-drag technique. Your screen should appear like this:




Comments

Most Popular