Return Portion of Variable

B

Benjamin

I have a variable Being the Cell's contents (Which are the file path name)

i.e. I'm using the file path, and it's important that I search the variable
Documents\Priority
Documents\Concerns
Documents\Attachments

I want to do an if statement for all paths that have
Documents in the variable I want to do "Action B" for example and everything
else:
"Action A"

How to I search for just "Documents" in the Variable
 
R

RB Smissaert

Lookup the Left function (best to use Left$ as it is faster) or Instr in the
VBA help.

RBS
 
Top