Forum Discussion
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!