via https://youtu.be/TM_Lk60uzZA

In this video, I show you 4 simple ways to combine first and last names or other separated text.

Enter first names in column A & last names in column B

Method 1: CONCAT (starting at 0:10)

  • Click in cell C2 & select CONCAT function
  • Text 1 = A2, Text 2 = ” “, Text 3 = B2
  • Formula: =CONCAT(A2,” “,B2)

Method 2: CONCAT Range (starting at 1:45)

  • Insert a column of spaces (insert a column between A&B, enter a space in B2 & copy & paste down column B)
  • Click in a blank cell & select CONCAT function & select a range of A2:C2
  • Formula: =CONCAT(A2:C2)

Method 3: Use & (starting at 2:58)

  • Click in a blank cell & type = then click in the first name cell, then type &, then type ” “, then type &, then click in the last name cell
  • Formula: =A2&” “&B2

Method 4: Use TEXTJOIN (starting at 3:51)

  • Click in a blank cell and select TEXTJOIN function
  • Enter a space for the delimiter, ignore empty = true, text1 = A2, text2 = B2
  • Formula: =TEXTJOIN(” “,TRUE,A2,B2)

IMPORTANT: Remember to copy & paste as values to preserve your work!

_________________________________________________________
Don’t forget to subscribe to my YouTube channel for more tutorials!