| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
separating data from imported txt file into cells
Any idea how I would separate out the following into cells for a stack
of data? It is currently in the format : 378265 COMPANY NAME Broker LOCATION 667050 TTL and I want to separate out where I have added the ¦ 378265 ¦ COMPANY NAME ¦ Broker ¦ LOCATION ¦ 667050 ¦ TTL LOCATION and Broker are the same across all entries. The other data is unique across entries. There are no commas. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating data to put in seperate cells | Excel Discussion (Misc queries) | |||
| Separating data from cells | Excel Worksheet Functions | |||
| separating imported data into 2 cell format | Excel Discussion (Misc queries) | |||
| Separating Numerical and Alpha Data in cells | Excel Discussion (Misc queries) | |||
| Separating Data in one cell to multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
