If extension of a path in a cell is .pdf then
On Apr 30, 10:31*am, Mark wrote:
On Apr 30, 10:02*am, cht13er wrote:
On Apr 30, 10:49*am, Mark wrote:
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?
=IF(RIGHT(E1,3) = "pdf", "External", IF(RIGHT(E1,4) = "html",
"Internal" , "Neither HTML nor PDF"))
Or do you need VBA code for some reason?
HTH
Chris
Oh do I just use this as a function for column F?- Hide quoted text -
- Show quoted text -
Actually, i modified the function to
=IF(RIGHT(E:E,3) = "pdf", "External", IF(RIGHT(E:E,4) =
"html","Internal", "Neither HTML nor PDF"))
Now, how do I get that function into every cell within column F using
VBA? If I paste the function into F:2, and then copy it into the rest
of the column, it says the same regardless if internal or external...
|