Title

Message

Confirm

Want to earn a free ClipboardFusion Pro license? We're looking for ClipboardFusion translators!
<< DiscussionsReply

Excel & Linebreak Removing Premade Macro

Avatar from Gravatar.com
FlinOrandee
7 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]
Apr 19, 2020  • #1
Thomas Malloch (BFS)'s profile on WallpaperFusion.com
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!
Apr 23, 2020  • #2
Avatar from Gravatar.com
FlinOrandee
7 discussion posts
Hi Thomas,

Excel 2016, 32 Bit
Version 16.0.12624.20422

Sincerely,

Flin
Apr 24, 2020  • #3
Avatar from Gravatar.com
FlinOrandee
7 discussion posts
Hi Thomas,

Any updates on this?

Sincerely,

Flin
29 days ago  • #4
Keith Lammers (BFS)'s profile on WallpaperFusion.com
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!
28 days ago  • #5
Avatar from Gravatar.com
FlinOrandee
7 discussion posts
Hi,

Got it. THanks for the kind help!! : )))

Sincerely,

Flin
28 days ago (modified 28 days ago)  • #6
Thomas Malloch (BFS)'s profile on WallpaperFusion.com
Sorry for the late reply!

It looks like the first thing the Macro did was copy, so it was actually clearing out the clipboard when you tried to paste the text from the PDF into Excel. I put together a new version of the Macro that doesn't copy text first. The way you should try to use this Macro now is:

  • Copy text from your PDF file
  • Use the Macro to paste text into Excel

Thanks!
27 days ago  • #7
Avatar from Gravatar.com
FlinOrandee
7 discussion posts
B I N G O ! ! !

Ah-MAY-zing!!!

When I see how carefully the you have team supports all your products, and the level of discrete coding expertise you bring to requests I feel impressed. Thank you Thomas, and Keith!



Sincerely,

Flin
27 days ago  • #8
Was this helpful?  Login to Vote  Login to Vote
<< DiscussionsReply