Hi Amy - this may get you started but please note that all the workbooks
which the formulae relate to should be closed.
Place the following into a general module
Function showformul(c As Range)
Application.Volatile
'The following is all one line if the text wraps.
showformul = Left(Right(c.Formula, Len(c.Formula) - 1),
Application.Find("[", Right(c.Formula, Len(c.Formula) - 1)) - 2)
End Function
To return the path from a formula contained in, say, cell C3, use
=showformul(C3)
--
XL2002
Regards
William
"Amy O" <Amy wrote in message
...
| I have a column with the following formula:
| ='\\Ourcompany\studydata\P_03\Lab\Manifest\Round 2\[Shipment 18 10
| 4.xls]Sheet1'!H18
|
| and would like to extract the workbook location from it. Is there a
formula
| to do this? Thanks.
| Amy