How to Combine Text in Excel (4 Methods: CONCATENATE, CONCAT, TEXTJOIN and Ampersand)
A common task in Excel is combining text that is stored in separate cells into a single cell - and there's more than one way to do it.
For example, you might have a list of First Names and Surnames stored in 2 columns which need to be combined, together with a space, into a single column
In this video I cover FOUR methods of combining text: Formula with ampersand; the CONCAT function, the CONCATENATE function and the TEXTJOIN function. Learn about the benefits and differences of each method.
For full details see the timestamps below:
⏱ Timestamps
00:00 Introduction
00:00:17 Combine text using a formula (the ampersand method)
00:02:15 Combine text using the CONCAT function
00:04:27 Combine text using the TEXTJOIN function
00:06:22 Combine text using the CONCATENATE function
🗒 Notes and Resources
Download a copy of the file used in this video: https://share.getcloudapp.com/E0ugmYoZ
The formulas that I used in the demos:
=CONCATENATE
=CONCAT
=TEXTJOIN
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #concatenate #textjoin