paste in excel

N

Nikhil

i have to copy data from sql query report to excel
worksheet. However all of a sudden today on....i am having
a problem with pasting in excel. Any string that i copy to
excel gets pasted in different cell and not in one single
cell

e.g say the string is "Green Color", it gets pasted in two
different cell (in cell a1 -> "Green", and in cell b1 -
"Color") instead of the same getting copied as a single
Click to expand...
string in A1.

plz let me know asap

regards

Nikhil
 
N

Nicky

I have sometimes had a similar problem after parsing (text to columns)
excel 'remembers' and tries to parse the pasted data. If this is th
source of your problem, changing the parse settings can help. If not
I've resorted to rebooting, which always works. I'll watch to see i
the gurus have a better solution
 
D

Dave Peterson

I bet Nicky got it right. You previously did a Data|text to columns.

When I see excel "helping" out like this, I either close excel (ugh!) or just do
a dummy Text to columns.

I put some garbage value in an empty cell.
data|text to columns|
Delimited
Uncheck all the options
And finish
Then clean up that garbage cell.
 
Top