extracting data from a cell

  • Thread starter Thread starter msam137
  • Start date Start date
M

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
 
Use Data | Text to Columns and use the space as a delimiter/separator.

Regards

Trevor
 
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
 
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
 
Back
Top