Separate Raw Data into Columns

Tutorials Shared by the Internet Community

Advertisements


Synopsis

Organize into columns from raw data that you got from somewhere else.

Statistics

  • Total Hits - 17188

  • Total Votes - 104 votes

  • Vote Up - 46 votes

  • Vote Down - 58 votes

  • Domain - www.excel-tutorials.org

  • Category - MS Excel/Basic Concepts

  • Submitted By - Devesh Khanna

  • Submitted on - 2008-04-27 00:19:48

Description

You know how some times you receive raw data in word and you really need to analyze it but you can’t do it in the format that was emailed to you. You have the option of taking this raw data and coping and pasting it onto an Excel spreadsheet, but it will probably dump the pasted data on one column. And you can’t analyze it like that. The solution is to split the raw data into columns. Many people don’t know about this handy trick that lets you split data from column into several other columns. In this short tutorial, I will show you the easy steps to get this done. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements