#Value retured in the result of some formulas

[capitarno]

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

 

[Andrew Poulsom]

FIND will return an error if the text isn't present. Try:

=IF(ISNUMBER(FIND("\",Filenames!B2)),LEFT(Filenames!B2,FIND("\",Filenames!B2)-1),Filenames!B2)

 

[Jonmo1]

Welcome to the board...

#VALUE! IS an error, so you can use iserror...

Try

=IF(ISERROR(FIND("\",Filenames!B2)),Filenames!B2,LEFT(Filenames!B2,FIND("\",Filenames!B2)-1))

 

[capitarno]

Many thanks

works a dream

 

[capitarno]

o