Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Converting Text files to Excel sheets with specific formatting
Hello, I have an issue with .txt files and excel. I have a text file that is outputted from our mainframe that needs to be converted to an exact excel format. The text output has tons of information that is not needed and hides pertinent information within long strings of useless data. The text appears something like this: 19923098981489098747791230980983097200409040970387 7891023478700011000234 The information that I would need out of the same string would be the following parts: 19923098981489098747791230980983097\\\\\20040904\\ \\\0970387789102347870001\\\\\\\1000234\\\\\ the 20040904 which is the date and 1000234 which is a test account number. The text file consists of about 20 to 25 strings like this per line. Each value needed would have to automatically fill a cell in a named column. Im not big on excel or data automation so Im here for some guidance please. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to search Excel files based on a specific text string in VBA c | Excel Discussion (Misc queries) | |||
Excel (xls) files spontaneously converting to text files | Excel Discussion (Misc queries) | |||
Converting specific text to numbers then sum | Excel Worksheet Functions | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) | |||
Converting text files to Excel - a difficult one | Excel Programming |