extracting data from a cell

[msam137]

I have this data that stored into several cells and each sell holds a
combined 20 data entries in one cell seperated by a space. I was
wondering is there anyway to extract that data with out having to rekey
the numbers. We are talking about a combined 2000 line items if
individually entered. An example is to store numbers 1-100 in to one

 

[Trevor Shuttleworth]

Use Data | Text to Columns and use the space as a delimiter/separator.

Regards

Trevor

 

[msam137]

Trevor that worked out great. Now part 2 of the phase since it seems
like the only way for that data to go is column what is the easiest way
to put it in each individual row. I prefer it to go veritcal rathen
horizontal. Any ideas

 

[Trevor Shuttleworth]

Select all the data and copy it.

Go to another area on the sheet or to another sheet. Note the areas cannot
overlap.

Select Edit | Paste Special | Click on Transpose and press Enter

Regards

Trevor

 

[msam137]

you are the best