Excel 2003 - copy / paste help please

  • Thread starter Thread starter bennos
  • Start date Start date
B

bennos

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - copy paste question 2
basic sum with a variable twist 3
Excel IF function in excel 2
Excel Average dates help 0
Basing math on duplicate entries in a formula 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel High lightng dates in future, today and past 1
function stumped 3

Back
Top