4 Ways to Combine Names or Text in Excel
HTML-код
- Опубликовано: 8 июл 2024
- 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 simplesoftwaretutorials.com
Video recorded using Screencast-O-Matic (www.screencast-o-matic.com)
Thanks for tuning in! Хобби
Thanks.