Need help setting this up?
If you'd rather not deal with the technical side, we can fully set up and manage your Microsoft 365 for you — including email, DNS, and ongoing support.
-
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.
-
Select Next.
-
Select the Column data format or use what Excel chose for you.
-
Select the Destination, which is where you want the split data to appear on your worksheet.
-
Select Finish.
Prefer us to handle this?
We provide fully managed Microsoft 365 setup and support — so you can focus on running your business.
