Often, you must divide the contents of a cell in your spreadsheet, separated by a comma or a space, such as a space. For example, the first and last name of a contact. Fortunately, Google Sheets provides a simple and straightforward approach to dealing with merged records.
Splitting Text into Google Sheets
Start your browser, open a Google Sheets document, and select all the cells you want to share up.
Warning: Make sure the cells on the right do not contain any data. This feature overwrites these cells without warning.
Then click Data> Split text into columns.
The data is immediately separated and stored in the column n next to the original.
Do not worry if your data is not separated by the specified options. The Custom option allows you to specify any character.
If you select a delimiter from the drop-down menu, select "Custom" instead.
Then enter the characters you want to separate in your records into the provided text box.
* A disadvantage of this method is the inability to separate data if they contain two different characters. To do this, you'll need to use the Sheet built-in SPLIT function, which we will discuss below.
Voila! The custom delimiter has removed all "@" instances in your cells.
How to Split Text with the Split Function
While using the previous function allows you to specify only an exact delimiter. You can use the SPLIT function to specify any number of delimiters for a record. For example, suppose your data is an e-mail address and you want to extract the user name, subdomain, and top-level domain in three columns.
Select an empty cell and enter
= SPLIT  ( G14 "@" ) where "G14" is the start cell. Press Enter.
. By default, each character of the delimiter is considered in quotation marks, unlike the previous method. Click in the string to "@" and return an unchanged record.
RELATED: The Best Add-ons for Google Sheets
Double-click this feature to apply to the blue square on the remaining cells.
The function does its magic and removes the separator from Your data.
Now you can use the splitting power of Google Sheets to move your data to different cells in your B rowser to separate spreadsheet.