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