Using Excel Functions: Concatenate

Excel, a spreadsheet, not a database...

Quite often people will create their address book in Excel. While entering the information and finding information is easy what isn’t easy is trying to get a printable version of your address book. If you do the normal File->Print route you’ll get a copy of the spreadsheet.

If you only have four or five names on your list then this isn’t much of a problem. But what if you had 70 or 80 names on your list and what if you had more columns than just the ones shown above? Then you would have to keep sliding the glide bar at the bottom of the spreadsheet back and forth to read them and to print them you would end up with 2 or more sheets.

There is a better way to display your information using one of Excel’s built in functions. The function is concatenate and in this hub I will show you how to use it to create a list with all the information you want together in a familiar format.

What is Concatenate?

Basically, concatenate means to join things together. That’s what we’ll be doing with the information on our spreadsheet, joining the fields together, formatting the new cell, and copying the function and formatting to all the names in our address book.

Those are the basics so let’s get started.

Concatenate is one of the most versatile functions in Excel--if you know how to use it. Well, now you do. Don't worry if you don't get it right the first time or possibly even the second. It can be tedious and that will sometimes lead to mistakes but once it clicks for you, which it will, you will begin to see uses for it everywhere. Good luck and have fun working with concatenate.


No comments yet.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.

    Click to Rate This Article