Last active
March 14, 2022 04:38
-
-
Save rameyrobo/7bdad9e4550f8ccc5a59abde4e4c38b8 to your computer and use it in GitHub Desktop.
Google Sheets Formulas
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // REMOVE BEGINNING OF N CHARACTERS OF TEXT | |
| // (Removes first three characters of strings located in array) | |
| =ArrayFormula(right(D1:D15,len(D1:D15)-3)) | |
| // (Removes the first character in first column and the first three columns in the second column) | |
| =ArrayFormula(replace(A1:B10,1,3,"")) | |
| // Remove text before 1st appearance of character "_" in this example. | |
| =if(ISTEXT(TRIM(LEFT(B1,FIND("_",B1) - 1))),TRIM(LEFT(B1,FIND("_",B1) - 1)),B1) | |
| // INDEX MATCH | |
| // Finds matching text in column and displays cell content adjacent to cells with unique string matches | |
| =index('Other Spreadsheet'!A:A,match(A1,'Other Spreadsheet'!B:B,0)) | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment