You can replicate the function throughout your column by copying and pasting your function throughout the column, or by clicking on the cell with the function and dragging the bottom right corner. Copy and paste the function throughout the column to concatenate other cells. Press the enter key to formulate your results in the new column:ģ. You can use this to ensure you’re concatenating the right strings. In the example above, you’ll notice that a preview of the results appears above the function. Remember to separate your strings with commas: In this case, let’s combine A1 with B1 so that the restaurant is in the same cell as its corresponding phone number. You can select a specific cell to pull the data from that cell, use text in quotation marks ("), or specify a range of cells. Your strings represent the information that you want to combine. Select the first cell in your new column and begin typing your function, =CONCATENATE(. Write the function in the first cell in your new column. We'll write our CONCATENATE function in this column, so by the end of this tutorial, your combined results will populate in this new column. To create a new column, right-click on a row, column, or cell and select + Insert 1 column (left or right) from the drop-down menu. Create a new column to the right or left of the cells you want to combine.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |