Excel 2000 - Data strings

B

Bax

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!!
<[email protected]>
 
J

Jonathan Cooper

A couple ways to work around it. The easiest is:

Select cells in question. It can only be one column, but this is how your
text is being pasted now.

Go to the DATA toolbar, click on "Text to Columns"

Delimited
Comma
OK
 
T

tjtjjtjt

One way:
After pasting it in:
Data | Text to Columns
Identify comma as the Delimiter.

tj
 
Top