Separate Raw Data into Columns

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Separate Raw Data into Columns

Organize into columns from raw data that you got from somewhere else.
http://www.excel-tutorials.org/columns/how-to-separate-raw-data-into-columns/
  • Total Hits: 13629

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 146 votes

  • Category: MS Excel/Basic Concepts

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

  • Submitted By: Devesh Khanna

  • Set as Favorite

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.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 38.36%  56
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.27%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.64%  17
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 10.96%  16
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.77%  42

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.






Advertisements