Ummm, and where do i put this?

(i know, pain in the neck to be blonde)

Sheila



On Mon, 16 May 2005 08:19:45 +0300, "Arvi Laanemets"
wrote:

Hi

=MID(CELL("filename";A1);FIND("]";CELL("filename";A1))+1;35)

The workbook must be saved, i.e. the formula doesn't work in freschly
created worlbook, until it is saved.
To refer to another sheet, replace A1 in formula with SheetName!A1.