Thankfully, it’s easy to take those cells and split up the first name and last names so that you can use them in any way you wish. If you want to separate names in Google Sheets, follow the steps below.
How to Separate Names Using SPLIT
The SPLIT function in Google Sheets allows you to split a text string up by looking for a separator such as a space or a comma. In this example, we will assume that your name data is in the form FirstName LastName, but the method can be tweaked to work with other formats, such as LastName, FirstName. To separate names in Google Docs using SPLIT:
How to Separate Names Using the Split Text to Columns
The SPLIT function creates two new columns with the separated name data and leaves the original name intact. If you would prefer to replace the original name with the separated name, you can use the Split Text to Columns tool. To separate names using Split Text to Columns:
How to Separate Names Using Text Functions
Both of the above methods create two columns of data, with one for the first name and one for the last name. In some cases, you may only want to extract the first or last name on its own. This is possible in Google Sheets by combining two different Google Sheets Functions. First, we use FIND to tell us the position of space within our text string. For example, if the space was the fifth character, FIND would return 5. Then we use LEFT to extract a set number of characters from the left of our string. Since we don’t want to include the space, we will select one less character than the number returned by FIND.
Extracting a First Name in Google Docs
To extract a first name in Google Docs using text functions: You can use the fill-down technique explained above to apply your formula to the other names.
Extracting a Second Name in Google Docs
The formula to extract the second name is slightly more complex. This is because the FIND function tells us the number of characters from the start of the string that the space appears. For the second name, we need to know how many characters from the end it appears, so we will subtract the position of the space from the total length of the text string. To extract a second name in Google Docs using text functions:
Manipulating Data in Google Sheets
If you’re trying to separate names in Google Sheets, the steps above should help you to get the job done. There are other ways to manipulate your data in Google Sheets, however. You can alphabetize your data to get it all into order, or highlight duplicates to find any repeated data. You can also use other conditional formatting rules in Google Sheets to make key data stand out or use filter views to see only the data you want to examine. Comment Name * Email *
Δ Save my name and email and send me emails as new comments are made to this post.
