View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DizzyD DizzyD is offline
external usenet poster
 
Posts: 2
Default 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...