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...
|