|
» Combining the Contents of Every N Number of Cells into One Value
CATEGORY: Excel Text Formulas |
VERSIONS: All Microsoft Excel Versions |
|
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. |
|
RATING:
2.91
VIEWS: 11761 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The Guide to Understanding Financial Statements
- Marketing Management
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Financial Modeling - 2nd Edition
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
Good