Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2000 - Data strings
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!! |
#2
|
|||
|
|||
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 "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!! |
#3
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Charting Data from Excel | Charts and Charting in Excel | |||
insert data from one excel file into another | Excel Discussion (Misc queries) | |||
pivotcell object to excel 2000 | Excel Discussion (Misc queries) | |||
Filtering data in Excel for mailmerge to Word | Excel Discussion (Misc queries) |