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

Posted by: ,

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

is a computer engineer, and presently a member of technical team that supports a leading health care company. Prior to his current job, 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 spend most of his idle hours in blogging and photography. Catch Bon thru bonistation.com and this site.

Related Posts

Print

Symantec and Microsoft Facilitate the Takedown of Click Fraud Botnet

Today, Symantec along with Microsoft announced the joint takedown of the command and control se ...
Microsoft Surface Pro Tablet Price Release Date

Microsoft Surface Pro Tablet Price Release Date

Microsoft Surface Pro Tablet Price Release Date. Geeks, following the release of the Surface wi ...
Microsoft Surface Tablet Price

Microsoft Surface Tablet Official Price, Specs

Microsoft Surface Tablet official price from Microsoft Store starts at $499 for the 32GB versio ...
Tokyo Game Show Biohazard and Final Fantasy XIV

Happening Now: Tokyo Game Show 2012

Konnichiwa gamers and geeks, here’s an update on the annual Tokyo Game Show that kicked off yes ...

Comments

comments