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?
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!