Excel Tips: How to extract data from one column to many
Excel Tips: When importing data into a worksheet, it is often necessary to separate the cell contents into two columns or more. You can accomplish it by using the Data Menu option “Text to columns”. Let’s say you need to split a list of addresses into three columns.
Follow these 5 easy steps:
1. Select A2:A6.
2. Go to Data Menu
3. Choose Text To Columns.
5. Check Comma (or choose what is appropriate) then Click Finish
* Special thanks to Ms. EP