63. Combining text using CONCATENATE

Combining Text Using CONCATENATE

**CONCATENATE** is a function in Excel used to combine text from multiple cells into a single cell. It's helpful for creating full names from first and last names, combining addresses, or formatting data.

Steps to Use CONCATENATE

  • Step 1: Select the cell where you want the combined text to appear.
  • Step 2: Enter the formula =CONCATENATE(A1, " ", B1), replacing A1 and B1 with the cells containing the text.
  • Step 3: Press Enter to combine the text.
  • Step 4: Drag the formula down to combine text for additional rows.

Interactive Example: Combine Text Using CONCATENATE

# First Name Last Name Full Name
1 John Doe --
2 Jane Smith --
3 Alice Johnson --

Click "Combine Text" to merge the first and last names into a single column (Full Name).

Comments