I am transfferring a MASSIVE amount of data from and excel worksheet into pdf files (working on tax returns).
Currently, If I simply click on a cell with data (lets say an address) and copy it, when i goto paste it into the pdf it inserts extra spaces at the end in additon to adding a line below the text, so i have to hit backspace a few times to clear that out. (there cannot be any extra nonsense in these forms as they will be e-filed).
My solution has been to manually highlight the contents of the cell from the formula bar and then paste it into the pdf. Doing it this way does not produce the extra spaces and "return key" effect. The thing is, that the constant highlighting is literally wearing out my hand and burning an extra second or two for every line item that i dont type in manually. When i am doing this hundreds of times, it adds up.
Is there a short cut or perhaps a macro i can bind to a ctrl+ command to copy the actual contents of the cell to the clipboard without absorbing non existent spaces and tabs?
(Baisically I want it to do what hitting "F2 -> CTRL+SHFT+HOME, CTRL+C" will do without so many darn key strokes.)
Bookmarks