copying data

[drizzle]

does anyone know how to copy data from Notepad file [Text Document] into Excel? the data I need to copy is two columns of numbers, but when I copy-paste them they appear as one column, I just couldn’t manage to separate them [they are about 40 pages long:cry:]. anyone have any suggestion, thanks in advance.

[junglebeast]

in Excel, go to Data->Import External Data->Import Data and select the text file. You can then choose delimmeters or spacing to import columns from the text file.

[drizzle]

cheers, that'll save a LOT of time :biggrin: