Select the cell or column that contains the text you want to split.
Select Data > Text to Columns.
In the Convert Text to Columns Wizard, select Delimited > Next.
Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.
In Google Sheet
Select the column of data that you want to split.
Go to the "Data" menu and select "Split Text to Columns"
In the Split Text to Columns dialog box, choose the delimiter that you want to use. In this case, select the semicolon (;)
Select the destination column for the split data and click "OK"
The data in the selected column will now be split into multiple columns based on the semicolon delimiter.
Alternatively, you can also achieve this by using the keyboard shortcut
Ctrl + Shift + L to access the same dialog box.