You're human. So when you look at the text Bob Tester`, computers take everything you tell them literally, which can lead to issues with data splitting like separating first and last names or addresses. To split text in Excel and Google Sheets, start by selecting the column or cell range with the text you want to split, then click Data and Text to Columns in Excel or Data and Split text to columns in Google Sheets. In Excel, select your delimiters, such as a space, comma, or custom value, and apply the changes, while in Google Sheets, use the Separator pop-up to select your delimiter and automatically guess how you want to split your data. With these tools, you can automate data organization tasks like formatting text for lead data upload to CRM and email marketing tools.