How To Split Cells In
Google Sheets
Open Google Sheets and select the cell containing the data you want to split.
Click on Data in the top menu and select Split text to columns from the dropdown.
Google Sheets will automatically detect a separator, or you can select one (comma, space, semicolon, etc.).
The data will be split into multiple columns based on the chosen separator.
If you need more control, use the TEXTSPLIT function with a custom delimiter.
