Note that it’s not enough to copy the column F onto A, because there are formulas in the former column – moreover, they are dependent on the latter column. The last step is overwriting the column A with values from column F. Then I used the fill feature to copy the formula onto other rows: I put that formula into the first available cell in the second row: F2. sometimes it’s possible to simply provide any larger number, e.g.the general formula is: LEN(A2) - starting position + 1. It will be equal to the length of the original text minus the 13 characters we want to be removed: the length of the fragment: unfortunately we can’t just ask for all text until the end without providing the length.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |