Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
don't want see file name with extensions. | Excel Discussion (Misc queries) | |||
File extensions | Excel Discussion (Misc queries) | |||
File extensions | Excel Discussion (Misc queries) | |||
File Extensions | Excel Programming | |||
XML file extensions | Excel Discussion (Misc queries) |