Some of the attendees at my Excel Boot Camp trainings have been thrilled to find that there’s this nifty function, which can combine many text columns into a single column.
Let’s say you have a column with First Name, and a separate column for Last Name, and you want to combine them to form the full name. How would you do it?
Want to Improve Your Excel Skills?
Learn the Key Features of Excel Quickly & Easily, by Joining the
Online Training on Basic / Intermediate Excel.
To Get Most out of Excel, Learn the Pivot Table techniques in our
Pivot Table Masterclass Training!
I have recorded a short video on how to achieve this, using 2 different methods. Check it out below:
Let me know if this works for you. And if you have any other method to achieve this, I’ll be glad to know it…
And check out my other Microsoft Excel Tips & Tricks videos on YouTube.
Are you facing any problem in using Excel? Any Question?
You have come to the right place. Tell us your needs. We’ll be glad to help you!