| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parse (TRIM) File Name into seperate columns
I have an .exe that reads a folder full of files and then
puts the complete file into column A. I would like to parse (trim) the file name into seperate columns. File name example:(Number of characters always same) ABC-040901-1015-incoming.dat I would like "ABC" in column A "040901-1015" in column B disregard remaining characters.. I have been trying TRIM and Left but can't get it to work. Any help greatly appreciated! Thanks... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I parse one column into different columns? | Excel Discussion (Misc queries) | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| Parse Data to Various Columns | Excel Discussion (Misc queries) | |||
| How do I parse columns? | Excel Worksheet Functions | |||
Threaded Mode
