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 - www.thetrainingsurgery.co.uk and click on the tips page.
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...