Copy link to clipboard
Copied
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?
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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!
Find more inspiration, events, and resources on the new Adobe Community
Explore Now