Hi,
I have a formula
=LEFT(Filenames!B2,FIND("\",Filenames!B2)-1)
which is pulling the first folder from a list of file names
The String CMT\Process returns CMT correctly as a value, however Process supplier returns #Value in my cell. (as there is no \ in the file name) There is no error in the formula so I dont believe I can use the ISError function.
Any guidance greatfully recieved
I have a formula
=LEFT(Filenames!B2,FIND("\",Filenames!B2)-1)
which is pulling the first folder from a list of file names
The String CMT\Process returns CMT correctly as a value, however Process supplier returns #Value in my cell. (as there is no \ in the file name) There is no error in the formula so I dont believe I can use the ISError function.
Any guidance greatfully recieved