Secondly, it replaces the last “\” character of the input string with a “*” character. ![]() ![]() įor instance, your file path is “C:\SomeFolder\Folder\Filename.doc” then this part would give you a value “3”.Ģ. This is accomplished by =LEN(A1)-LEN(SUBSTITUTE(A1,"\","")). First it finds how many “\” characters are present in the string. ![]() I will explain the above formula by breaking it into three parts:ġ. I know many of you would be interested to know the logic behind the above formula. While using this formula simply replace all the instances of cell position ‘A1’ with the cell position where you have file path present. Here in this formula, the only thing that you have to change is the cell position ‘A1’.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |