» Combining the Contents of Every N Number of Cells into One Value
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Marketing Plans That Work, Targeting Growth and Profitability
- Microsoft Word Version 2002 Inside Out
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The Intelligent Investor: The Classic Bestseller on Value Investing
Good