Select the cells that contain the text you want to split.
- Go to the Data tab on the Excel ribbon.
- Click on Text to Columns Option.
- Choose Delimited or Fixed width, then click Next:
- Delimited: Use this if the text is separated by commas, tabs, spaces, or other characters.
- Fixed width: Use this if the text is aligned in columns with spaces.
- Choose your delimiter (e.g., Comma, Tab, Space, Other).
- Click Finis
Put Comment for quarry