This is a follow up post to our recent post highlighting the new Flash Fill feature in Microsoft Excel 2013. In this post we show you how to use the Concatenate Function when Flash Fill isn’t available if you’re running another version of Microsoft Excel.
It sometimes happens where a spreadsheet containing text from different cells needs to be joined into a single string. By applying the CONCATENATE function, you can bring text together without having to rip apart your spreadsheet or tearing you hair out!
Watch this video to see the Concatenate function in action, if you’re running Excel 2013 we will recap the Flash Fill option for you. Or read and check out that video post here: Flash Fill in Excel 2013
Like these tips? Get a free trial to Log on to Learn and access 100% of our content free for 7-days! Or call Log on to Learn at 800-831-8449 for details on corporate pricing! Rates are as low as $99!
