Excel 2003 - copy / paste help please
 

Hope I can get an answer here!! Otherwise I'm going to be at work all night.

Here is the problem:
I used to be able to click and drag some info (date, amount, qty) from a
website and paste it on an Excel file, this would place each (date, amount,
qty) into it's own cell. But today (and yesterday) it is putting all the info
(date, amount...) into one cell only.

I hope that explaination was OK?! My question is: Is there an option I need
to look at to revert back to putting all the data into individual cells?

Thanks in advance!
Ben

Excel 2003 - copy / paste help please
 

you could try using the text to columns function under the data toolbar to
separte back out into individual cells after copy/paste of data.
--
joec


"bennos" wrote:

Hope I can get an answer here!! Otherwise I'm going to be at work all night.

Here is the problem:
I used to be able to click and drag some info (date, amount, qty) from a
website and paste it on an Excel file, this would place each (date, amount,
qty) into it's own cell. But today (and yesterday) it is putting all the info
(date, amount...) into one cell only.

I hope that explaination was OK?! My question is: Is there an option I need
to look at to revert back to putting all the data into individual cells?

Thanks in advance!
Ben