| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
extracting data from a cell
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 cell seperating the numbers by a space. |
|
#2
|
|||
|
|||
|
Please don't waste everyone's time by multi-posting.
See the reply in microsoft.public.excel "msam137" wrote in message oups.com... 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 cell seperating the numbers by a space. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want a window to cell data that conains links to PDF files and . | Excel Discussion (Misc queries) | |||
| How do I change a cell so I can have the data it contains in seve. | Excel Discussion (Misc queries) | |||
| How do I copy data from a cell in one file to another? | New Users to Excel | |||
| Repeat Cell Data | Excel Worksheet Functions | |||
| Load active cell data via a function | Excel Worksheet Functions | |||
Linear Mode
