Excel enquiry?
I have a massive data set which i need to statistically analyse. when i copy the raw data into excel it occupies one column even though it appears as three columns inside column a. how should i time efficiently separate these 3 columns into recognisable columns in excel i.e. a,b,c? the data set consists of 1000's of individual datum so it would be a life saver to find out!
Answer
Use file > open in excel to open your text file. you need to select the file type of .txt. you will have the options to select delimiters or fixed width. without seeing your text file, i don't know which option is the best but try them. there is only a few and if it fails, close it without saving and try again until you get it.
Related Products
Warning: DOMDocument::loadXML() [
domdocument.loadxml]: Extra content at the end of the document in Entity, line: 2 in
/home/gmartin/public_html/ukmicrosoftquicktips/includes/domxml-php4-to-php5.php on line
61
Fatal error: Call to a member function document_element() on a non-object in
/home/gmartin/public_html/ukmicrosoftquicktips/includes/amazon.php on line
50
