Forum Discussion

enloe11's avatar
enloe11
Copper Contributor
May 23, 2022

Copy and Pasting Nonsense

Hey guys, I'm sorry if this has been asked or is an easy fix, but I cannot find it anywhere on the internet. I keep getting the same results but not for the problem I am having. 

 

The example I will use for my issue is this;

I have a 5 digit number entered into a single cell. (Three cells merged into one, but does the same with data in single cells) I click on the cell and ctrl+c to highlight and copy said cell. I am then leaving excel to paste the number and I am getting tab spaces that are being copied behind the number. Anywhere from 1-4 tab spaces behind each thing copied. There are absolutely no spaces anywhere in the data, but any time I copy it, it comes out like this - "12345    ". or something similar. It also adds in and "enter" at the end because it will drop lines after the paste. 

 

Why does it do this, and how do I keep it from doing this? I want to copy that cell and paste the data exactly that is in it without all the other jazz. 

 

If you answer is to either ctrl+f and find all the spaces or use =Trim, That cannot be done. Im typing in 12345 into a cell and coping it, there is nothing else to be done.


Thanks for the help!

 

 

No RepliesBe the first to reply