В Пекине открылся Государственный комитет КНР по контролю

To get the Excel file path or name, you can use the CELL function to implement it indirectly. 1. Use =CELL("filename") to obtain complete information containing paths, file names and worksheets; 2. Use LEFT and FIND functions to extract only paths, the formula is =LEFT(CELL("filename"), FIND("[", CELL("filename")) - 1); 3. Use MID and FIND to extract file names, the formula is =MID(CELL("filename"), FIND("[", CELL("filename")) 1, FIND("]", CELL("filename")) - FIND("[", CELL("filename")) - 1). Note: These formulas are only valid when the file is saved. Unsaved files may return empty values ??or error results, and the formula needs to be nested with other functions to accurately extract the required information.

If you want to get a file path in Excel using a formula—like the full path of the current workbook or worksheet—you won't find a built-in function that does this directly. But there are a few workarounds and formulas that can help pull this information indirectly.

Here's how you can do it:

Use CELL Function to Get File Path

The CELL function in Excel can retrieve some information about cell formatting, location, or contents. One of its options lets you get the file path when combined with other functions.

Formula:

 =CELL("filename")

This returns the full path, including the workbook name and sheet name, like:

 C:\FolderName\[WorkbookName.xlsx]Sheet1

If you only want the file path (without the sheet name), combine it with LEFT , FIND , and CELL :

 =LEFT(CELL("filename"), FIND("[", CELL("filename")) - 1)

Note: This formula works only when the workbook has been saved at least once. If it's a new, unsaved file, it will return an empty string or incorrect result.

Extract Just the Workbook Name

Sometimes you just need the workbook name without the full path or sheet name. You can extract it by combining MID , FIND , and CELL again:

Formula:

 =MID(CELL("filename"), FIND("[", CELL("filename")) 1, FIND("]", CELL("filename")) - FIND("[", CELL("filename")) - 1)

This gives you something like:

 WorkbookName.xlsx

Useful if you're building dynamic references or creating reports that include the file name.

Limitations and Tips

• ? Workbook Must Be Saved : As mentioned earlier, these formulas only work properly on saved files. Otherwise, they might return unexpected results or blanks.
• ? Combine with Other Functions : These formulas often need to be nested inside others ( LEFT , RIGHT , MID , etc.) to extract exactly what you need.
• ? Named Range Option : You can create a named range using the CELL("filename") function so it's easier to reference elsewhere in your workbook.
• ? Not Dynamic in All Contexts : While these formulas update when the file is moved or renamed, they don't automatically refresh unless the sheet reccalculates.

So yes, while Excel doesn't have a dedicated "get file path" function, you can use the CELL function creatively to extract the path, file name, or both. It's not perfect, but it gets the job done in most practical situations.

Basically that's it.

The above is the detailed content of how to get the file path in excel using a formula. For more information, please follow other related articles on the PHP Chinese website!