Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Example:

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

CTRL-C/CTRL-V

<a href="http://www.domain.com
">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
2  
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
add comment

1 Answer

up vote 3 down vote accepted

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

share|improve this answer
1  
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
add comment

Your Answer

 
discard

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.