Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text file to Excel
Hello
A colleague receives, periodically, a text file. It is a huge one. It contains name details, then a series of numerical data. They need to convert this into an excel document, but the first obstacle concerns the names. The first entry, of course, is the title, followed by initials. The problem is, the number of initials can vary from none to 4 or more. How can we export the Text file into Excel, so that the surname column always appears as column 3, with however many initials all in column 2? Then the rest of the data all lnies up as well. The rest of the data is not variable in length. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) |