REGEXEXTRACT: Find Specific Pieces of Text This function returns parts of text in a cell according to a specified pattern. For example, you might want to separate numbers and text.

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.