» 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:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Microsoft Office XP Introductory Concepts and Techniques
- The One Page Business Plan: Start With a Vision, Build a Company!
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
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?
