Identify cells containing a file name and move them to a separate column

[Parkaz]

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

[dosydos]

=TRIM(RIGHT(SUBSTITUTE(A1,"\",REPT(" ",LEN(A1))),LEN(A1)))

Try this assuming data starts in cell A1

[Parkaz]

That is fantastic. I can't figure out how it works but it works great

thanks

[Parkaz]

Interestingly I ran an exact check to make sure all were the same and about a dozen out of 3000 came back false. I found that my data had 1 more character space than your result. Is this a formula issue or do I just need to trim my original data?

My data Labor Report Letter.pdf
Result from your formula Labor Report Letter.pdf