+ Reply to Thread
Results 1 to 2 of 2

Copy cell content to clipboard to paste into a pdf

  1. #1
    Registered User
    Join Date
    01-24-2014
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    10

    Copy cell content to clipboard to paste into a pdf

    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.)

  2. #2
    Forum Contributor yay_excel's Avatar
    Join Date
    08-12-2011
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    190

    Re: Copy cell content to clipboard to paste into a pdf

    Check out PhraseExpress. It does what you need plus much more. Very useful program. http://www.phraseexpress.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro to move 1 cell left and paste CURRENT clipboard content as HYPERLINK
    By sgoesef in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 01:31 PM
  2. [SOLVED] Copy cell A1 and paste value into B1 if B1 has content, paste to B2...etc
    By mhopke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2012, 09:39 PM
  3. Replies: 3
    Last Post: 04-13-2012, 12:26 PM
  4. Copy content of cell to clipboard
    By amitmodi_mrt in forum Excel General
    Replies: 3
    Last Post: 09-08-2009, 11:26 AM
  5. Copy and paste row based on cell content
    By BDan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 11:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1