I thought you wanted the book name as well.

Glad you are sorted.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ssGuru" wrote in message
ups.com...
OK. This works
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-1)
Bracket needed to be reversed

Thanks Bob for getting me started in the right direction.

Dennis