Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

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

New Here ,
Aug 10, 2016 Aug 10, 2016

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?

TOPICS
Acrobat SDK and JavaScript , Windows
1.5K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Aug 10, 2016 Aug 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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 14, 2016 Sep 14, 2016
LATEST

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!

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines