How to extract file extensions?
I have a directory listing for all the files in a particular drive.
With excel macros, I have extracted filenames with extension in column
E. like filename.xxx
i need to extract the extensions in Column F. Now, column E does not
have all files with extensions.
Extension should be extracted with a condition of having a dot and 3
letter extension.
Can someone please help me in writing a small code?
|