If you've ever had a list of first and last names that you wanted to separate Excel and Google Sheets make it easy. Here's how to do it in each application.
How to Use the TEXTSPLIT Function in Microsoft Excel makeuseof.com - get the latest breaking news, showbiz & celebrity photos, sport news & rumours, viral videos and top stories from makeuseof.com Daily Mail and Mail on Sunday newspapers.
There can be circumstances when you need to divide cells in Excel. These could be the point at which you get the information from a data set or you duplicate it from the web or get it from a partner.