4 Ways to Combine Names or Text in Excel

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)

Don't forget to copy & paste as values to preserve your work!

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

Check out my website at https://simplesoftwaretutorials.com

Video recorded using Screencast-O-Matic (http://www.screencast-o-matic.com)

Thanks for tuning in!

Видео 4 Ways to Combine Names or Text in Excel канала Simple Software Tutorials