Now Reading
Excel Tips: How to extract data from one column to many
1

Excel Tips: How to extract data from one column to many

by Bon Francisco Talampas, Jr.October 18, 2012

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.

Microsoft Excel Text to Column

Follow these 5 easy steps:

1. Select A2:A6.
2. Go to Data Menu
3. Choose Text To Columns.

Microsoft Excel Text to Column

4. Choose Delimited
Microsoft Excel Text to Column

5.  Check Comma (or choose what is appropriate)  then Click Finish

Microsoft Excel Text to Column

* Special thanks to Ms. EP

What's your reaction?
Thumbs up!
0%
Cool
0%
Happy
0%
Laugh
0%
Sad
0%
Angry
0%
Gun
0%
About The Author
Bon Francisco Talampas, Jr.
Bon Talampas, Jr. is a computer engineer, a former member of a technical team that supports a leading health care company. Prior to his stint abroad, he worked as an IT specialist and a university lecturer. Bon also holds an MBA. And aside from being a computer geek and DOTA fanatic, he spends most of his idle hours in blogging and photography. You can also read more about him at www.bonistation.com.
  • Ayun! Kaibigan ko palagi sa work ang Text to Columns na yan.. Gamit na gamit.. Ahehehee..