Inserting/Pasting a column of text in Block mode from Excel

[wtowne]

I would like to insert a column of text copy/paste from Excel. Everytime I do this directly from excel textpad creates new lines for each row of text instead of inserting the text. If I paste the excel text into a blank textpad document, then copy it from that document while in block mode, then paste it, it does insert the text. I would like to paste directly from excel into textpad.

This used to work in earlier versions. Around 1999 vintage.

Anybody know if this is possible anymore. If the question doesn't make sense just try to paste a column from excel.

Thanks
Willie

[talleyrand]

Maybe it will make sense to someone else. I am able to highlight a portion of a column (8 lines in my example) in Excel 2000 (9.0.2720) and paste it into Textpad (4.7.1) just fine. I can insert it either block mode or line mode and both behave as I expected --- the contents of my cell are inserted. I've even tested it with text that has been bolded, italicised and bolded and italicised. Am I missing something?

[wtowne]

I am in Excel 2002 with windows 2000 and textpad 4.7.1. Below is what happens to me.

original file

1 5
2 6
3 7
4 8

After pasting 3 lines of text in block mode from excel

1 9
10
11
5
2 6
3 7
4 8

After pasting 3 lines of text from textpad to textpad in block mode. This is what I desire.

1 95
2 106
3 117
4 8

Notice how pasting from excel creates new lines where pasting from textpad just inserts the text.

Is this not what you saw?

Thanks,

[talleyrand]

[edit]Perhaps it's an Excel 2002 thing[/edit]
Before

Code: Select all

1 5
2 6
3 7
4 8

Copy text from Excel

Edit, Paste (with cursor at the end of the 5)

Code: Select all

1 59
10
11
2 6
3 7
4 8

Copy text from Excel

Edit, Insert, Paste as Block (with cursor at the end of the 5)

Code: Select all

1 59
2 610
3 711
4 8