Skip to main content

All Questions

107 votes
23 answers
248k views

How to copy multi-line text from Excel without quotes?

When you create a multi-line string in an excel cell (by using Alt-Enter), if you copy that cell to a text editor, excel will automatically add double quotes (") around the full string, ie: Cell1 | ...
Andrew Bickerton's user avatar
67 votes
11 answers
263k views

Excel copy-paste: always match destination formatting

I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when ...
Leftium's user avatar
  • 9,267
6 votes
3 answers
19k views

Paste to Excel from clipboard (plain text) : Can I make certain cells to be formatted "as such"

when preparing table data as text to be copied to Excel through clipboard, is it possible to have certain cells unformatted? (If possible, without changing Excel settings or doing a special paste). ...
touko's user avatar
  • 272
1 vote
1 answer
2k views

Why is copy paste losing all formatting by default?

Lately whenever i copy paste something (in particular within Office) by default i lose all formatting. To copy the formatting have to retry copying the content several times before it works. So far i ...
mundeep's user avatar
  • 380