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