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
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...
The following Cookies are used on this Site. Users who allow all the Cookies will enjoy the best experience and all functionality on the Site will be available to you.
You can choose to disable any of the Cookies by un-ticking the box below but if you do so your experience with the Site is likely to be diminished.
In order to interact with this site.
To help us to measure how users interact with content and pages on the Site so we can make
things better.
To show content from Google Maps.
To show content from YouTube.
To show content from Vimeo.
To share content across multiple platforms.
To view and book events.
To show user avatars and twitter feeds.
To show content from TourMkr.
To interact with Facebook.
To show content from WalkInto.