My fun tricks with Excel just keep coming. Recently I posted a blog about how to split data into multiple columns. That is great and can come in handy, but sometimes, you need those first and last names in the same column. It is easy to just type them if there are 5-10 but when you get into the hundreds and thousands…not so much.
Let’s say A1 contains “Lady” and B2 contains “Dame”
Insert a new column in after B and in the new C column type
=A1&” “&B1
Boom
C1 now says “Lady Dame”
Hopefully this not only saves me next time I am trying to remember this fun trick, but for those of you who find it can from now on remember that combining two columns in excel is not as hard or time consuming as some think!
No comments:
Post a Comment