Combining text in Excel can be very useful in many situation. There can be various use cases like combining first name and last name, combining address and zip codes, combining phone number and country codes etc. Concat function helps in combining text in Excel. In this article we will discuss in detail how to concatenate text in Excel?
John has customer spend data for his company. He is looking forward to combine first name and last narme to create full name column. For example the the first cell in I5 should contain “Anallise Ellerman” which is made by combining First Name “Anallise” and Last name “Ellerman”.
Combine texts with Concat function to Lower Case
- Step 1: In Concat function the cell containing texts that needs concatenation are added one after the another. Text 1 a comma text 2 another comma and so on. We will add an space between the two text E5 and F5, ” “. This will make Full Name properly formatted with a space inbetween.
=CONCAT(E5," ",F5)
Thus John is clear on the steps on How to concatenate text in Excel. Feel free to reach us for any queries.
To get top certifications in Microsoft Excel and build your resume visit here. Also, you can read books listed here to build strong knowledge around Microsoft Excel.
Please visit our video tutorial to go through the example as well:
Share your feedbacks if you like the article. Like and share for more such content.
📬 Stay Ahead in Data Science & AI – Subscribe to Newsletter!
- 🎯 Interview Series: Curated questions and answers for freshers and experienced candidates.
- 📊 Data Science for All: Simplified articles on key concepts, accessible to all levels.
- 🤖 Generative AI for All: Easy explanations on Generative AI trends transforming industries.
💡 Why Subscribe? Gain expert insights, stay ahead of trends, and prepare with confidence for your next interview.
👉 Subscribe here:
La educación permanente abre nuevas perspectivas