Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I extract text as a value from a formula?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
formula is displaying as text rather than result. | Excel Worksheet Functions | |||
match cell text with text in formula | Excel Worksheet Functions | |||
Logical Text Formula | Excel Worksheet Functions | |||
Extract % from text string | Excel Worksheet Functions |