• Hey, guest user. Hope you're enjoying NeoGAF! Have you considered registering for an account? Come join us and add your take to the daily discourse.

Pasting data into excel

Status
Not open for further replies.
I have to perform a regression on it, and since i dont have those functions on my home computer, im stuck in the lab.

If anyone could tell me the function to paste a .txt file into it (where each horizontal space switches it over a column, and each vertical space switches it down a row), it'd save me a few hours of copying and pasting.
 

golem

Member
Data -> Import External Data -> Import Data

you should be able to open a text file, and specify that the different fields are delimited with spaces...
 
Status
Not open for further replies.
Top Bottom