I am attempting to build an index of all my files on a specific subject. I have about 3000 files. The full path is contained in one column. I do a text to columns operation using \ as the delimiter. This puts each folder in a separate column with the actual file in the last column. Unfortunately some folders have many subfolders and some have none so the actual file can appear in any column. I would like to search for just the file name and put them all in a single column so I can sort them. So far the only way I have been able to do it is filter on each column (I use conditional formatting that highlights the cell with the file in it). I then copy the files from that column to a new column. I have to repeat this filter for each column. Is there a simple way to identify the cell with the file in it and have it copied to a new column. All file names are in the format: filename.XYZ
Thanks in advance
Parkaz
Bookmarks