Hi

I have file names in column with A123_STUV_XYX.pdf and some files name A567-XYZ_ABC.pdf .
i want output STUV_XYZ.pdf and XYZ_ABD.pdf ,i tried with LEFT and FIND i did not getting desired out.