This is the strangest thing. I am coping the value of one cell with CTRL+C. Say L1 and the value of L1 is
='[blahblah.xls]HL-.TSTT.-Location'!A8
Then I click E1 and I want it to paste there but when I click CTRL+V it paste the data into Cell E1, F1, and G1 but its not duplicated its spaced out like its been tab delimited. Any idea how I did this and how to change it back so that I can copy one cell and paste into only one cell. haha
Last edited by Jack7774; 03-20-2015 at 08:25 AM.
Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
Sorry if this is a duplicate response...looks like the first one didn't post for some reason.
Sounds like you have a residual Text to Columns setting... I'd just try to reset it, then try again.
If you are copying the *contents* if the cell - using F2/highlight/ctrl C, then going to the next cell and just pressing CTRL V, I have seen this happen as well - it spreads the copied text/formula across a number of cells.
If that is how you copied, then to paste, you need to F2, andthen paste there
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Wasn't residuals, if you meant data analysis residuals settings. If something else please elaborate.Originally Posted by JP Romano
Either way for whatever reason it was doing it, it has stopped doing it today once I logged out and logged back in.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks