Concatenating Text
The opposite of parsing text is concatenating text. To parse text, we start with a long piece of text and separate it into pieces. To concatenate, we start with two or more pieces of text and “string them together.” For example, we might parse “Bob Jones” into “Bob” and “Jones”. In the other direction, we might concatenate “Bob” and “Jones” into “Bob Jones”. The key to concatenating in Excel is the ampersand symbol, &.
To concatenate the text in cells A1 and B1, for example, enter the formula =A1&B1 in cell C1. Literal text can also be included, such as =A1&“, ”&B1. In this case, if A1 contains “Jones” and B1 contains “Bob”, then C1 will contain “Jones, Bob”. This concatenates the last name, a literal comma and space, and the first name.
Try it! Concatenate the first names, middle initials, and last names in columns A, B, and C so that full names of the form Jones, Bob E. appear in column D.
Dostları ilə paylaş: |
