search

sabrogden / Ditto

Ditto is an extension to the Windows Clipboard. You copy something to the Clipboard and Ditto takes what you copied and stores it in a database to retrieve at a later time.
https://ditto-cp.sourceforge.io/
3.93k stars 208 forks source link

Paste a line to Excel #681

Open cezarmoniz opened 5 months ago

cezarmoniz commented 5 months ago

Hello everybody. I would like to paste the memory into an Excel line as per the example below:

Ditto AAAAA BBBBBB CCCCCC

Excel AAAAA BBBBB CCCCC

It is possible?

Thanks a lot

gggirlgeek commented 4 months ago

Use Special Paste --> Remove line feed. I'm not sure, though, if it only removes that last line feed, or removes all line feeds in the clip. But it's worth a try.

Also, in Excel, if you're trying to separate the data into individual cells across, instead of cells down, use the "Transpose" option, after pasting the text, and selecting all the filled cells.

If you want all the data in one long cell, with spaces between words, there is an option to convert the pasted data, and ignore any delimiter such as carriage returns (Enter), line feeds, Tabs, Spaces, and almost any other character. Look under the Data menu and you should find it. Excel may also automatically popup this conversion dialogue when you paste those rows into one cell. It will have line feeds checked by default. Uncheck it and enable Spaces instead. Play around until you get what you want. Depends on your settings and how the rows are formatted. You may also need to add the spaces first (below.)

Last, you may need to use a text editor like Notepad++ or Microsoft Word (maybe even Excel??) to "Find and Replace" (Ctrl+H) line feeds with spaces or Tabs (^T or \t normally.) I think returns are indicated by ^R or ^Q or \r but it's been years since I've done it in Word.