I was asked by a client to look at their directory structure and permissions to make some suggestions about how it could be improved.
I used AccessEnum (see link below) to pull out the details required and saved them as a unicode text file. After importing this into Excel I noticed some of the directory paths were huge, so wanted to find a quick and easy way of finding the path length.
I ended up using the Excel 2010 function LEN(text), where text is the string you want to find the length of.
In my case I created another column. In the cell adjacent to the directory path selected Autosum – More functions option, LEN. Typed in the cell number of the directory path cell. Then used Ctrl – D, to copy the formula down the required number of cells.