If always be a "_" after 'Acrobat*', try this version.
=REPLACE(O9,1,FIND("_",O9,SEARCH("Acrobat",O9)),"" )
If always be a "_" after 'Acrobat*', try this version.
=REPLACE(O9,1,FIND("_",O9,SEARCH("Acrobat",O9)),"" )
Posting Permissions
Reply With Quote
Bookmarks