# Combining the Contents of Every N Number of Cells into One Value

1. Its really good, I was using "&" but that doesn't give the space between two columns.

Good

2. ## Combining the Contents of Every N Number of Cells into One Value

Problem:

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.

Solution:

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1