Try:

Path and filename

=SUBSTITUTE(SUBSTITUTE(LEFT(CELL("filename",A1),FI ND("]",CELL("filename",A1))),"[",""),"]","")

filename only

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

Mike

"Sandy" wrote:

Hello
I am opening a 8.prn file formatting the data and then moving the data into
another file. In the formatting portion I would like to add the filename to
A1. I think I need to use cell("Filename") but I am not quite sure how. Can
someone kindly help?
Thanks!