PDA

View Full Version : Pasting data into excel


McLesterolBeast
06-15-2004, 01:55 AM
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
06-15-2004, 02:15 AM
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...

McLesterolBeast
06-15-2004, 02:20 AM
thanks