Excel copy/paste into Third Party Software

[brianr-is]

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.

 

Brian.

[brianr-is]

Hello All,

 

I figured this out:

 

When copying from a column in Excel, to eliminate trailing spaces in column:

 

1. Highlight Column.

2. Click on Left Justify.

3. Click on Data\Text to Columns.

4. You're ready to script.