Finding the character length of a cell in Excel 2010

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 AutosumMore 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.

http://technet.microsoft.com/en-us/sysinternals/bb897332.aspx

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.