» Combining the Contents of Every N Number of Cells into One Value
Column A contains an imported list of addresses; however, each address has been distributed over 4 cells.
Therefore, we want to combine the contents of each block of four cells so that the addresses will appear as complete entities.
Use the IF, MOD, and ROW functions as shown in the following formula:
=IF(MOD(ROW()-ROW($A$2),4)=0, A2&" "&A3&" "&A4&" "&A5," ")
Enter the formula in cell B2 and then copy it down the column until all the addresses in column A are recombined.