Copy from Excel without Line Break

ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Copy from Excel without Line Break

Message par ForumBot »

Copy from Excel without Line Break
ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Re: Copy from Excel without Line Break

Message par ForumBot »

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:

[https://stackoverflow.com/q/14695836/145173](https://stackoverflow.com/q/14695836/145173)

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.
Répondre

Revenir à « Excel & VBA »