Premium Only Content

How to merge multiple cells in Excel with TEXTJOIN | Excel Practice Case #18
How to merge multiple cells in Excel with TEXTJOIN | Excel Practice Case #18
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
In this video we learn a new function TEXTJOIN, introduced in Excel 2016.
The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
Until recently, there were two prevalent methods to merge cell contents in Excel: the concatenation operator and CONCATENATE function. With the introduction of TEXTJOIN, it seems like a more powerful alternative has appeared, which enables you to join text in a more flexible manner including any delimiter in between. But in truth, there's much more to it!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉
SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👉Teespring Merch&Books 👉 https://bit.ly/3S1fa7n
Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🤳Dexcelo on TikTok 👉 https://bit.ly/3JgslNU
📥 Business Inquiries 👉 dexcelo03@gmail.com
📊 In this course you will learn how to:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Merge the full address in one cell
- The TEXTJOIN function combines the text from multiple ranges
- TEXTJOIN accepts a delimiter to use when joining values together
- Use the TEXTJOIN function to merge the cells
- Use the shortcut CTRL + D to paste the formulas to the below cells
- TEXTJOIN is a more compact function than CONCATENATE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:02:27 Intro & Objectives
0:02:27 - 0:06:42 Using TEXTJOIN
0:06:42 - 0:08:24 Using CTRL + D
0:08:24 - 0:10:24 Objectives Summary
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
-
52:40
Candace Show Podcast
2 hours agoSaturday Night Lively: What Were They Thinking? | Candace Ep 148
45.7K50 -
2:02:21
Revenge of the Cis
3 hours agoEpisode 1449: Boo This
19.1K2 -
1:20:31
Awaken With JP
4 hours agoWiping Hard Drives, Hire a Criminal Defense Lawyer - LIES Ep 79
54.4K33 -
1:02:23
In The Litter Box w/ Jewels & Catturd
21 hours agoDEI Kills | In the Litter Box w/ Jewels & Catturd – Ep. 744 – 2/18/2025
65.3K35 -
DVR
Game On!
3 hours agoBreaking Down COLLEGE BASKETBALL BETTING LINES Like a Pro!
4.17K2 -
1:01:29
John Crump Live
5 hours agoMexico Backs Cartels By Threatening To Designate Gun Manufactures As Terrorist!
4.64K4 -
LIVE
The Nunn Report - w/ Dan Nunn
3 hours ago[Ep 611] DOGE On The March! | Guest Sam Anthony - [your]NEWS | Seditious Dems | Ukraine
295 watching -
1:00:56
The Tom Renz Show
9 hours agoThe War On DOGE Is ALSO A War On The Economy
18.8K6 -
1:30:16
Steve-O's Wild Ride! Podcast
5 days ago $1.26 earnedAri Shaffir Exposes The Dark Side of Podcasting - Wild Ride #252
25.8K3 -
1:56:29
The Quartering
6 hours agoAirplane FLIPS and CRASHES, Sean Duffy Slams Pete Buttigieg, & What Happened with Patriarchy Hannah
78K36