So one of the biggest hurdles to analysing a dataset can be that it imports in an ugly way. Maybe some elements that belong together in one cell were split int different ones. Or, perhaps you just want to combine a number of strings in certain cells.
So while there’s always the CONCATENATE function, here we look at an even simpler way of doing this using the ampersand (&) symbol. Check it out. Click for sound.
Produced by Daniel Goodman
Business Insider Emails & Alerts
Site highlights each day to your inbox.