I have several thousand path/filenames in a spreadsheet, one path\filename per cell in column A. I'm trying to figure out a formula that will extract the filename only. The problem is finding the last "\" and then extracting everything to the right. There could be zero or many "\" characters. Any help is appreciated. Sample data:

c:\FileB.jpg
controls.txt
c:\documents and settings\UserA\FileA.txt
c:\SOP\containers\dishrack\types\explanation.doc

Thanks, Mark