It may have been affected by a "Data/ Text to columns" operation. If a
space has been set as a delimiter, Excel tends to remember this. Try doing
Data/ Text to columns again, removing the tick against space as a delimiter.
Now try your troublesome paste again and see whether it behaves differently.
--
David Biddulph

"trainer07" wrote in message
...
Somehow I enabled a function that pastes each word of a copied set of
words
into a separate cell, rather than grouping them into one. I now must
press
F2, to step into the cell prior using ctrl-v to paste. Quite a nuisance
actually, & I can't seem to find a way to disable it in the options, or
Excel
help. For example, if cell A1 contains the words: Sales Meeting. When I
copy and paste it into cell B1, the word, "Sales", goes into B1 and the
word,
"Meeting", goes into B2.
Any advice?
Thanks!