Concatenate- Join up columns in Excel
6th June 2010
... Comments

Hello there

Last week I did not publish a tip as I took advantage of the long bank holiday weekend to spend a few days away with my lovely husband. We had a great time and now I am back with this week's tip.

Concatenate in Excel

Concatenate I hear you say - What on earth is that?

Simply put it means joining up the contents of two fields into a new one. For example if you have a contact list in Excel with the columns

FirstName    Surname you may find that you now wish to have a Salutation or Full name column.

Concatenate can do this for you without you needing to key in the information all over again! Yippee.

Concatenate for Excel 2003 2007 and 2010 (Windows)

Concatenate for Excel 2008 (Mac)

Remember if you are struggling with a Microsoft Office feature, drop me an email and I will write a tip just for you! (and everyone else who reads my tips...)

For more handy tips visit my website - and click on the tips page.

Have fun


About the Author

Shelley F

Member since: 6th January 2011

Shelley Fishel is the Founder and Managing Director of The Training Surgery, an IT training company that focuses on the needs of the clients. Training in your office, with your documents focussed on your...

Popular Categories