One way:
After pasting it in:
Data | Text to Columns
Identify comma as the Delimiter.
tj
"Bax" wrote:
I have no problem useing copy/paste to move a data string from an E-mail to a
WORKS spread sheet. Example: 1,3,2,5,25,26,32,15. The numbers appear in
succesive cells. 8 separate cells in the example and can be exercised
separately.
When useing the more powerful EXCEL 2000 however, the same procedure
deposits all the numbers in a single cell and makes them unuseable in
subsequent descriminating calculations. CAN THIS BE AVOIDED? HOW? Thank
You for any help!!
|