Microsoft Office Tutorials and References
In Depth Information
Editing formulas
INSIDE OUT Practical concatenation
Depending on the kind of work you do, the text manipulation prowess of Excel might
turn out to be the most important skill you learn in this topic. If you deal with a lot
of mailing lists, for example, you probably use a word-processing application such as
Microsoft Word. But you might find that Excel has the tools you’ve been wishing for,
and it just might become your text-manipulation application of choice.
Suppose you have a database of names in which the first and last names are stored in
separate columns. This example shows you how to generate lists of full names:
We created the full names listed in columns D and E using formulas like the one visible
in the formula bar. For example, the formula in cell D2 is =B2&" "&A2, which
concatenates and reverses the contents of the cells in columns A and B and adds a space
character in between. The formula in cell E2 (=A2&", "&B2) reverses the position of the first
and last names and adds a comma before the space character. For another nifty—and
related—trick, see the sidebar “Practical text manipulation” in Chapter 14. And for an
even niftier related feature that is new in Excel 2013, see “Automatic parsing and
concatenation using Flash Fill” in Chapter 8, “Worksheet editing techniques.”
You’ll find the Concatenation.xlsx file with the other examples on the companion website.
Search JabSto ::

Custom Search