Microsoft Office Tutorials and References
In Depth Information
In Figure 16-3, the full names displayed in Column C are concatenated from
the first and last names in Columns A and B, respectively. In the function’s
arguments, enter a space between the references to cells in columns A and B.
You enter a space by enclosing a space between double quotation marks,
like this: “ ”.
There is another way to concatenate strings. You can use the ampersand (&)
character instead and skip using CONCATENATE altogether. For example,
another way to create the full names seen in Figure 16-3 is by entering the
following formula in the target cell: =A3 & “ ” & B3. Either method gets the
job done. There really is no compelling reason to use one over the other —
it’s up to you, empowered user!
You can give this a whirl on your own. Surely, you must have a list of names
somewhere in an Excel workbook. Open that workbook, or at least enter first
names and last names on your own, and then do the following:
1. Position the cursor in an empty column, in the same row as the first
textentry,andenter =CONCATENATE( to start the function.
2. Click the cell that has the first name, or enter its address.
3. Enter a comma ( ,).
It should look like this: “ ” .
5. Enter a comma ( ,).
6. Click the cell that has the last name, or enter its address.
7. Type a ), and press Enter.
8. Use the fill handle to drag the function into the rows below, as many
You can combine text strings two ways: use the CONCATENATE function or
use the ampersand (&) operator.
There must be a whole lot of issues around text. I say that because a whole
lot of functions let you work with text. There are functions that format text,
replace text with other text, and clean text. (Yes, text needs a good scrubbing
at times.) There are functions for just making lowercase letters into capitals
and capital letters into lowercase.