OK simple question for any excel pros ...dirrectory tree report created, - want to be able to sort the output so the longest is top or the bottom and it deprecitates going to the shortest. Also, I would like to be able to create a new cell on the right and get the count of chracters used for the file path, So like this..
Add this formula to the 'Total Chars' column and sort on that. Code: =len(A1) =len(A2) =len(A3) .... edit: It'd be easiest to have the path in column A then the formula in column B (no blank columns)
ok cool now how can I apply that to all feilds in G going down wards? Edit, ok cool copy A1, all the way down and it updates it.
pm me your email for pal £ also for ref why I am doing this, ntfs has a file limitation of 255 chracters, Through bad data management basicly some dirrectorys have exceeded the 255 limit, I need to work on this and a report to see whats going would be helpfull, the data is just standard business reports, pdfs, excels, research...
Interesting as I had the same issue at work earlier this year. Migrating to a new file server/SAN, although we have software to rename directories pre and post copy as there's over 4TB of office files it'd take forever doing that manually! You can put a conditional formatting to highlight the over length paths. http://www.howtoexcelatexcel.com/excel-tips-tricks/conditional-formatting/