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.

I’m Chris Malanga and I’ve been an Educational Technologist with the Northern Buckeye Education Council/NWOCA since 2016. In this role, I help teachers, administrators, and students integrate technology into our schools. My passion is helping people develop skills to change the world of education!