Put some dummy data in A1.......this is dummy data

DataText to ColumnsDelimitedSpaceFinish

Delete that and try pasting in your table.


Gord Dibben MS Excel MVP


On Tue, 27 Jan 2009 14:43:02 -0800, Penthawk
wrote:

Something has changed, or I have done something. For several years I've cut
and pasted football tables, bank statements, that kind of thing from my
sources onto an excel spreadsheet to check my running budgets, football
tables, etc.
If I do it now and copy the table, when I paste it on the spreadsheet it
copies the whole table in the first cell horizontally. The only filled cell
is the first cell.
What has happened? What have I done or tweaked or messed up? Is this an
Excel error? I work from home doing sports trading and I now can't use Excel.
I don't want to go to a substitute Office program. Been with MS Office for
about 20 years now.
Thank you if you can help. John.