If you’re like me, you get some really messy data in Google Sheets. I have found some very easy ways to clean up this data and make your sheets look really nice. In this Tech Tip, I will focus on three topics – split columns, CONCAT and CONCATENATE, and removing text using the find and replace feature.
Before I get started, I do want to remind you that Google Sheets has TONS of help built in. Under the Help menu, click Function list and you will be taken to a searchable list of functions that are built-in to Sheets. For each function, there is the syntax and a link to learn even more.