Enter Details

Comment on stories, receive email newsletters & alerts.

This is your permanent identity for Business Insider Australia
Your email must be valid for account activation
Minimum of 8 standard keyboard characters


Email newsletters but will contain a brief summary of our top stories and news alerts.

Forgotten Password

Enter Details

Back to log in

How To Organise Messy Data And Combine Cells In Excel

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.

Follow Business Insider Australia on Facebook, Twitter, LinkedIn, and Instagram.