Experience the Power of CONCAT Function in Microsoft Excel

Effortlessly Combine Text from Multiple Cells with CONCAT

One of the most useful things one might do in Microsoft Excel is combine strings of text in two or more cells into one. First and last names, addresses, or custom messages: CONCAT is the function that you use to manipulate strings.

CONCATENATE is the classic one; CONCAT, however, is the new version, available in Microsoft Excel's 365-2016, without any hiccup.

📘 What is CONCAT in Excel?

It combines two or more text strings into one. This is handy when you want to combine the contents from two cells, without the cost of losing your precious data.

Syntax: 

=CONCAT(text1, [text2], ...)

• text1: The first item to combine (could be a cell reference or text)

• text2: Optional second one to combine

✅ Example: Combine First and Last Names

Say columns A and B contain first and last names.

In column C, type:

=CONCAT(A2, " ", B2)

That returns: John Doe, Sarah Patel, Michael Smith

🧠 Use Case for CONCAT

Join names/addresses/descriptions

Join ID numbers with codes

Create dynamic messages or custom sentences

Help in report creation or label generation

💡 Tips for USING CONCAT EFFECTIVELY:

Use spaces or punctuation with " ", ", ", or " - ". 

Wrap formulas with TRIM() to remove extra spaces. 

Use TEXT() to format numbers before combining. 

Example: 

=CONCAT("Invoice #", A2, " - $", TEXT(B2, "#,##0.00"))

❓Which one to use: CONCAT vs CONCATENATE vs TEXTJOIN

With the CONCAT function, one can quickly clean, customize, and combine text in Excel. The small tool has great potential to boost your productivity!

🎓 Learn More with Other Levels

Take your Excel skills to the next level:

• 🌐 Visit our Other Levels Website

• 📺 Watch free tutorials on our Other Levels YouTube Channel, and learn Microsoft Excel from beginner to advanced.

Other Articles, Tips & Tricks you would like:

• Master Flash-Fill in Microsoft Excel
• Top 10 Microsoft Excel Tips and Tricks
• Build an Attendance Tracking HR Dashboard in Excel – Step-by-Step Guide

Work Faster, Smarter, Productively and Efficiently with Other Levels Dashboard Template

• Daily Maintenance Operations Dashboard
• Sales Team Performance and Metrics Excel Dashboard
• Sales by Region Excel Dashboard