A quick Excel Question
-
In OO and MS Works spreadsheets, when I select a group of cells and then copy them to the clipboard the content is tab-delimited. Is this also the case with Excel? Just a need-to-know type thing and I don't have Excel on my machine.
Everybody SHUT UP until I finish my coffee...
-
In OO and MS Works spreadsheets, when I select a group of cells and then copy them to the clipboard the content is tab-delimited. Is this also the case with Excel? Just a need-to-know type thing and I don't have Excel on my machine.
Everybody SHUT UP until I finish my coffee...
-
DaveAuld wrote:
Just tried a copy and paste from excel to Notepad and it appears so
Thank You! :)
Everybody SHUT UP until I finish my coffee...
-
In OO and MS Works spreadsheets, when I select a group of cells and then copy them to the clipboard the content is tab-delimited. Is this also the case with Excel? Just a need-to-know type thing and I don't have Excel on my machine.
Everybody SHUT UP until I finish my coffee...
Yeah, one other thing to watch for in this case... Even if you do not copy contiguous cells you get them all... IE: If you select a few cells in one row using the control key so you can select individual cells and do a copy and paste you end up with ALL the cells from the first selection to the last. For example, if you have the numbers 1 through 10 in columns A through J, and you use the CTRL key and select columns B, D and F, then do a copy and paste into notepad you will get all the values from columns B through F, even the ones you didn't select. Seems odd but that's how it works for some reason.
-
Yeah, one other thing to watch for in this case... Even if you do not copy contiguous cells you get them all... IE: If you select a few cells in one row using the control key so you can select individual cells and do a copy and paste you end up with ALL the cells from the first selection to the last. For example, if you have the numbers 1 through 10 in columns A through J, and you use the CTRL key and select columns B, D and F, then do a copy and paste into notepad you will get all the values from columns B through F, even the ones you didn't select. Seems odd but that's how it works for some reason.
Thanks In this case I was just making sure this was uniform across the major spreadsheet apps for loading delimited text into another program. Merry Christmas!
Everybody SHUT UP until I finish my coffee...