Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have a several large columns of data stored in notepad. The columns are all
next to each other. I need to put column 1 in column A in excel and column 2 into column B in excel etc. Copy and paste does not work. I cant just highlight one column I end up highlighting all 6 columns! If a just copy a paste all the data, the entire data just goes into column A of excel, and I can not perform any excel functions on the data. HELP! This is extremely annoying, I am beginning to think the only way is to copy each bit of data by hand into excel, but there over 1000 items!!! HELP!!!!!!!!!!!!!!!!!!!!!!!! |
#2
![]() |
|||
|
|||
![]()
Please! You have posted 4 messages in 4 minutes, see answer to one of your
previosu posts -- Regards, Peo Sjoblom "JJ" wrote in message ... I have a several large columns of data stored in notepad. The columns are all next to each other. I need to put column 1 in column A in excel and column 2 into column B in excel etc. Copy and paste does not work. I can't just highlight one column I end up highlighting all 6 columns! If a just copy a paste all the data, the entire data just goes into column A of excel, and I can not perform any excel functions on the data. HELP! This is extremely annoying, I am beginning to think the only way is to copy each bit of data by hand into excel, but there over 1000 items!!! HELP!!!!!!!!!!!!!!!!!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do i set up excel to copy from one cell to a given number of . | Excel Discussion (Misc queries) | |||
How do I transfer data from Notepad to Excel? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions |