» Combining Text from Different Cells
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
The & symbol consolidates text information in the same way as the + symbol adds numbers. The space between quotation marks adds a blank character between the separated texts.
To combine text with the &:
1. In cell A1, enter the text F1.
2. In cell A2, enter the text Get the Most out of Excel!
3. In cell A3, enter the text The Ultimate Excel Tip Help Guide.
4. In cell A5, type the formula:
=A1&" "&A2&" "&A3
Technique 2: Using the Concatenate Formula
The Concatenate formula allows one to combine text from multiple cells into a single cell.
To combine text use the Concatenate formula:
The Concatenate formula is in the Text category in the Insert Function dialog box. To add a blank character between words, press Spacebar in the second and fourth argument box.
Book Store:
Recommended Books:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Learn MS Excel 2002 VBA/XML Programming
- The Basics of Finance: Financial Tools for Non Financial Managers
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Microsoft Outlook 2002 for Dummies
How to indent?
Peter
If you're combining several cells into one (in my case, making address labels by combining several cells of contact info - name, zip code, address, etc) how do you indent so that each piece of information is on a different line in the same cell? So that, in my case, it's in an appropriate address format - Name on top, then address underneath, then zip?
