In this video, you'll learn how to use Excel's TEXTJOIN function to combine cells in Excel, the advantages of using TEXTSPLIT over other methods like CONCAT, and a few TEXTJOIN hacks that will blow your mind.
TEXTJOIN is a newer TEXT function that allows you to combine cells in Excel with a specified delimiter between each value. A delimiter can be a character, space, phrase, symbol, whatever you’d like! This function makes combining values in Excel easier than ever.
First, we’ll review how to combine first, middle, and last names into full names. Then, we'll discuss the advantages of TEXTJOIN vs. the CONCAT function. Lastly, we’ll discuss how to prep an email list to be pasted into Outlook by inserting a semicolon between each email address.
RESOURCES
Download the workbook and follow along: https://exceldictionary.com/pages/yo...
SHOP EXCEL DICTIONARY
COURSES: https://exceldictionary.com/collecti...
GUIDES: https://exceldictionary.com/collecti...
MERCH: https://exceldictionary.com/collecti...
TEMPLATES: https://exceldictionary.com/collecti...
NEWSLETTER
Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: https://www.exceldictionary.com/subs...
SUBSCRIBE
Subscribe to never miss a video: / exceldictionary
TIMESTAMPS
‘0:00 Intro
‘0:24 Combine first, middle, and last name
‘1:52 TEXTJOIN vs CONCAT
‘2:40 Combine emails for Outlook
‘3:14 Wrap up
#excel #exceltips #tutorial