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