Explanation
The replace function lets you replace text based on its location and length.
In this case, we want to strip off the drive and path and leave only the document name.
For example =REPLACE(“XYZ123”,4,3,“456”) returns “XYZ456”.
Remove text by position
To remove text from a cell by position, you can use the REPLACE function. In the example shown, the formula in C6 is: =REPLACE(B6,1,24,"") which replaces the first 24 characters in the text with an empty string ("").
