In cell D2, enter:
=A2&" "&B2&"."&" "&C2
This is saying "merge cell A2, and space, and cell B2, and period, and space, and cell C2"
This should merge all three, plus the period after the initial and spaces to the new cell. Good right? Well, that takes care of one cell, and we need to apply this relative formula to the rest of the column. To do that, we need to drag and drop the formula.
Place your cursor in the lower right hand cell of D2 until it become a small black cross, and then drag down until it highlights all cells in the column that you wish to merge the data. When you release, it will apply the relative formula to all those cells and merge the columns. Voila!
Below are a few pics to help:
Setting up the intial formula:
Dragging and dropping the formula:
The finished merged columns:
This will save you a lot of time, so you can get back to watching YouTube. Enjoy!
Who is online
Users browsing this forum: No registered users and 1 guest