FlinOrandee
18 discussion posts
Hi,
Got great help with the attached macro! Thank you for that.
I'm pasting a lot from PDF files into Excel.
The attached Macro DOES remove the linebreaks if pasting to Word, or to Notepad.
But, can't seem to find a way for it to do the same when pasting to Excel.
I tried clicking inside cells and pasting directly. Nothing pastes, though the Macro does execute.
I tried pasting into the Formula bar. Same results.
What do you think is happening?
Sincerely,
Flin
• Attachment [protected]: Remove Linebreaks and Empty Lines.txt [2,073 bytes]
Thanks for your kind words!
Some Microsoft Office programs like Excel do some wacky things with the Clipboard that sometimes aren't compatible with ClipboardFusion. Would you be able to let us know what version of Excel you're using so we can try testing here?
Thanks!
FlinOrandee
18 discussion posts
Hi Thomas,
Excel 2016, 32 Bit
Version 16.0.12624.20422
Sincerely,
Flin
FlinOrandee
18 discussion posts
Hi Thomas,
Any updates on this?
Sincerely,
Flin
Apologies for the delay! Thomas has been out of the office but he's back tomorrow, so he should get back to you by the end of the week.
Thanks!
FlinOrandee
18 discussion posts
Hi,
Got it. THanks for the kind help!! : )))
Sincerely,
Flin
May 7, 2020 (modified May 7, 2020)
•
#6
