![]() 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.from which character the fragment should start: it will be 14 (ignore the first 13 characters and start from the 14th).We have to use a function that will take a fragment of a string: MID. Apparently, this is a simple task, because the text to be removed has always the same length: 4 characters of “pick”, 1 for space, 7 characters of the hash and again 1 for space 13 characters in total.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |