![]() In the following example, we've entered a formula =A2 &" " &B2 in C2 and then copied the formula down to the cells below by dragging the Fill handle on the bottom right corner of the cell: If you wanted to add a space between the data, you would enter the following formula in C2: If you want to add text, enter it in quotation marks or double quotes.įor example, if you wanted to combine the data from cells A2 and B2 (such as first name and last name), you could enter the following formula in C2: Repeat for other cells or items you want to add.Type the cell reference for the cell you want to combine or click it. ![]() Type the CONCATENATE operator (&) by pressing Shift + 7 (at the top of the keyboard). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |