File Path Length Excel

[RJ1969]

Hello,
How can I check to see how length my file is in excel? What key do I need to press?

Also, how can I fix or shorten it so I won’t have any problem or losing the file. This has been happening lately in some of my file.
Thank you.

[oeldere]

If the name of the file is in A1 you can use in b1 = LEN(A1)

[RJ1969]

Hi
I placed the code in A1 … this code "b1 = LEN(A1)"
but it does not do anything. It did not show the length of the code.

Thanks.

[oeldere]

is the name of the file in cell A1.

If so you can extract the length of cell A1 (the name of the file) in cel B1 with the formula.

in cell B1 = LEN(A1)

[RJ1969]

I think I should say its the workbooks name.

Let say the name of the workbook is Book1.

[oeldere]

with the formula in cell B1 the result wil be 5

is suppose the dot is not in the name of the file.

[RJ1969]

Hello

Ok U need a formula that will total the length of the file name. The file name that includes the path the leading to the other folder.


Thanks

[RJ1969]

*I need the formula

Thanks

[maniacb]

Try

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

For file name and

=LEN(MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1))

For its length

[RJ1969]

Do i place this formula in a new worksheet in any cells?

Thanks

[maniacb]

Yes, although the formula may not work for your version of Excel. I hope it does

[RJ1969]

Hi
I tried to put the code but get a #value result.

See attachment.

[BMV]

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

RJ1969
the full path limitation is 260 characters but for excel with links it must be less because of 31 for sheet name , extra spec symbols such as []'' and range address.
However it is not possible to loose file. The file can be not accessible but and it could be fix. Move parent folder to different on (c:\1) rename folders.
Also you can archive folders structure and then extract onle files . Some programs such as Robocopy and Total Comander also work with very long path.

[maniacb]

You can also try just

=CELL("filename")

in any cell

[Sc0tt1e]

cell a1 paste this

Cell b1 paste this

[BMV]

@ maniacb, Sc0tt1e
=CELL("filename") return file path and caller sheet name. Book name will be in the square brackets also.

[Sc0tt1e]

I see what you mean

[RJ1969]

Got it!

Thank you all !

[RJ1969]

Question:
What is exactly the maximum of length of the document? What will happen if you go over the max?

Thank you

[BMV]

For NTFS is not limited
For explorer and moust programm full path must be less 260 characters
but for excel 218 characters https://support.microsoft.com/en-us/...rs=en-us&ad=us

[RJ1969]

Ok... Thank you.

[RJ1969]

Question guys,

Do I need to change "filename" to the name of the workbook?

Should it be automatically change "filename" to its workbook name?

Not the worksheet name, right?

Please Login or Register  to view this content.