Jump to content
Macro Express Forums

Excel copy/paste into Third Party Software


Recommended Posts

Hello All,


When copying from Excel, how do I removed the trailing spaces from cells within a column? Currently when I copy from Excel and paste to a Third Party Software, the paste includes trailing spaces after the mnemonic. For example, I copied PHET25 a drug mnemonic in Excel which has 6 characters but, when I paste into the Third Party Software, I get 12 spaces and as a result the Third Party Software thinks it’s a new item with 12 characters. I only want to paste the contents of the cell (6 characters) and not the trailing spaces.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...