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)3. Fill out the rest of the column using the same click-and-drag technique. Your screen should appear like this:
Comments
Post a Comment