Skip to main content
L
LARector
Participant
August 10, 2016
Question

Copy & Paste from Excel to Fillable Form - Extra Spaces?? How do I get rid of them?

  • August 10, 2016
  • 1 reply
  • 1558 views

I have to copy and paste data from an Excel spreadsheet into a fillable .pdf form created by the government. I've noticed that when I copy and paste, it adds an extra space to each field in the .pdf form. That's not a problem except for one field on the form and that's the date. When I paste, it adds an extra space and the form states invalid date and won't accept unless I backspace to delete the extra space. That doesn't seem like much except for when you have 3000 entries then it's tiresome. Is there some way to fix this so it doesn't add the extra space to each field?

This topic has been closed for replies.

1 reply

G
George_Johnson
Inspiring
August 10, 2016

This is a problem with Excel, since it adds one or two carriage return/linefeed combinations when you copy & paste. You can find things (e.g., scripting) to do in Excel to prevent this, though I don't have the specifics. You should be able to find something with a search, like: copy paste - MS Excel adds line break when copying a cell - Stack Overflow

L
LARectorAuthor
Participant
September 14, 2016

Just for information purposes, you can also copy and paste your data into a Google Docs spreadsheet and use that. It doesn't add the extra carriage return. Thanks for your previous help!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices