Monday, September 20, 2010

How To Convert Text To Columns In Excel

I have sometimes needed to create a working data sheet from a large section of text. As an analyst and data organiser it is often your responsibility to take unformatted information and turn it into useful, meaningful, organised and workable data. When might it be required? Some databases extract data in the form of text files. Not all users are experienced and it is entirely possible that clients will send data in this format. Rather than making them re-do it to your required format, it is much better if you can transform it yourself. Another reason may be that data is on a worksheet, but needs to be formatted properly to be of use. An example would be a column containing the full name of clients. In order to put the data from the sheet into a database it needs to be in two columns called First_name and Surname. Sometimes when copying and pasting into Excel, Excel places the data into one column rather than separating it. This would also require separation.

The full article appears here:
http://www.microsofttraining.net/article-1116-how-convert-text-columns-in-excel.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com

0 Comments:

Post a Comment

<< Home