Excel 2007 - How to separate text to columns

When you open .csv file by Excel and that .csv file did not use comma as separater, you will get all text are in Cell A.

Here is how to separate those text to columns

1. Select Cell you want to separate text
2. Go to Data menu -> Click at Text to Columns button



3. Choose Delimited file type and click Next > button



4. Specify Delimiters or separator here and click Next > button



5. Select Data Format for each column, and click Finish button



6. Here they are!!!