| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
parsing data into Excel
Hi,
I have a file I have brought into Excel. It contains tens of thousands of records. I need to parse the data from this format: JOHN DOE 1.16 AC P O BOX 229 MT STORM WV 26739 To this format JOHN DOE PO BOX 229 MT STORM WV 26739 1.16 AC I would appreciate any help or suggestions. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
parsing data into Excel
Are you using 'data'...'text to columns' to parse into the various fields?
Depending on what all of your data looks like you will use delimited or fixed length, you might want to experiment with that. " wrote: Hi, I have a file I have brought into Excel. It contains tens of thousands of records. I need to parse the data from this format: JOHN DOE 1.16 AC P O BOX 229 MT STORM WV 26739 To this format JOHN DOE PO BOX 229 MT STORM WV 26739 1.16 AC I would appreciate any help or suggestions. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
parsing data into Excel
Hey tim m,
Thanks, I did try that. My biggest problem is that the data I have is in the same colunm and I need to spread the elements into the same row. After I do that the text to column feature will work for me on most of the data. Thanks, kim tim m wrote: Are you using 'data'...'text to columns' to parse into the various fields? Depending on what all of your data looks like you will use delimited or fixed length, you might want to experiment with that. " wrote: Hi, I have a file I have brought into Excel. It contains tens of thousands of records. I need to parse the data from this format: JOHN DOE 1.16 AC P O BOX 229 MT STORM WV 26739 To this format JOHN DOE PO BOX 229 MT STORM WV 26739 1.16 AC I would appreciate any help or suggestions. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
| Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
| Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
