Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I copy text from a cell in Excel and paste into a text document a line break is appended.


<a href="#">Some Link</a>


<a href="
">Some Link</a>

Is it possible to copy as plain text without additional line breaks added?

share|improve this question
Can't you press F2 and copy the cell's contents? – Karan Jan 29 '13 at 20:01
F2 edits a cell – Charles Wesley Jan 29 '13 at 20:03
What Karan means is, that you press F2 → Select the cell content with your arrow keys → copy&paste it with CTRL+C and CTRL+V – nixda Jan 29 '13 at 20:06
Ah I understand. That does work. If one of you posts as an answer I'll accept it. Thank you! – Charles Wesley Jan 29 '13 at 20:08
An equivalent question on StackOverflow has a macro-based answers that minimizes keystrokes. – Edward Brey Jul 9 '15 at 21:40
up vote 6 down vote accepted

Simply press F2 to edit the cell, select all text (Shift+Home ought to do it, or Ctrl+Shift+Home for multi-line cell), then copy (Ctrl+C) and paste (Ctrl+V) without line breaks being added.

share|improve this answer
BTW, here's a macro and AHK script if you want to do this for lots of cells and want to make things easier. See here if you want help with adding a reference to the Microsoft Forms 2.0 Object Library required to make that macro work. – Karan Jan 29 '13 at 20:20

Ctrl+C > Ctrl+V > Backspace is probably better than the accepted answer due to fewer key strokes. I know this doesn't really answer the question, it sounds like your question is really a feature request. As mentioned in the comments here is a macro solution as well:

Sounds like too much work to me to avoid a backspace key stroke. If it's large grabs and pulls, I would just suggest using Notepad++'s advanced find/replace and exploit the \n\r\t characters that are the real text appended to the copy/paste and replace them with nothing.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.