Sublime Forum

Issues pasting from Excel

#1

I have over 10K lines of concatenated string that I want to copy from Excel and paste into Sublime. I have special pasted them so the lines are no longer in the formula so only the string exists
As an example it looks like this in one column in Excel:

(‘Lady Of the House Ladybug’, ‘Amazon’, ‘Home & Kitchen’),
(‘Neutral Luxe Handmade’, ‘Amazon’, ‘Home & Kitchen’),
(‘on the boardwalk canvas wall art multi/none no size’, ‘Kohl’s’, ‘Home & Kitchen’)

I can copy and paste a few of these lines into Sublime. I can copy the whole 10K from Excel, but I am unable to paste them into Sublime. What could be the issue and how can I resolve this so that I can paste more than 3 lines into Sublime. I had to copy/paste from Text Wrangler to make it work.

Thanks!

0 Likes
#2

Can you paste all these 10K lines in other editor other than Sublime Text?

If not, it means that excel is not allowing you to copy more than 3 lines.

0 Likes
#3

I’ve been able to do this in the past so it’s really odd that I am unable to do this now. Any suggestions on how to fix this?

0 Likes
#4

I’m not sure if it will help, but you might want to check out the Sublime console (View > Show Console) and see if it displays an error messages in there when the paste fails.

Is this all one huge long line, or 10k discrete lines of text all in a block?

1 Like
#5

Still not answering the question:

Can you paste all these 10K lines in other editor other than Sublime Text?

Perhaps now, Excel has broken something with a update.

0 Likes
#6

This is 10k discrete lines. Each line is in a separate row in Excel.

0 Likes
#7

I can paste the 10K lines in TextWrangler. But I was not able to do so with Visual Studio Code.

0 Likes
#8

Can you reproduce with a clean install of Sublime Text after reverting it?

  1. https://www.sublimetext.com/docs/3/revert.html
0 Likes