Amy,
By the workbook location, you mean everything before the start of the File
Name but not including the equal sign or the single quote?
In other words, this:
\\Ourcompany\studydata\P_03\Lab\Manifest\Round 2\

If this is correct . . .
If this data is in cell A5, how about:
=MID(A5,FIND("'",A5,1)+1,(FIND("[",A5,1)-FIND("'",A5,1))-1)

tj


"Amy O" wrote:

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