Thread: If extension of a path in a cell is .pdf then
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_66_] Mark[_66_] is offline
external usenet poster
  
Posts: 24
Default If extension of a path in a cell is .pdf then
Hello

Was wondering how to go about this. I have a bunch of file paths all
in column E. I wanted to generate either "External" or "Internal"
into column F depending on whether the file extension is .pdf
or .html.

Any ideas?
Reply With QuoteReply With Quote