Combine cells using &.
Databases tend to split out data to make it as exact as possible. For example, instead of having a data that shows a person's full name, a database might have the data as a first name and then a last name in separate columns. Or, it may have a person's location separated by city, state, and zip code. In Excel, you can combine cells with different data into one cell by using the "&" sign in your function.
The formula with variables from our example below: =A2&" "&B2
Let's go through the formula together using an example. Pretend we want to combine first names and last names into full names in a single column. To do this, we'd first put our cursor in the blank cell where we want the full name to appear. Next, we'd highlight one cell that contains a first name, type in an "&" sign, and then highlight a cell with the corresponding last name.
But you're not finished -- if all you type in is =A2&B2, then there will not be a space between the person's first name and last name. To add that necessary space, use the function =A2&" "&B2. The quotation marks around the space tell Excel to put a space in between the first and last name.
To make this true for multiple rows, simply drag the corner of that first cell downward as shown in the example.
We hope you found this article helpful! Bookmark it to keep these handy Excel tips in your back pocket.
If you have any query or want any help related to excel feel free to join our Telegram channel and message us..
Channel link :
0 Comments