About 1,297,327 results (2,256 milliseconds)
Formula to match a sub-string in a cell and do a SWITCH match ...
https://support.google.com/docs/thread/25941198/formula-to-match-a-sub-string-in-a-cell-and-do-a-switch-match-against-it?hl=en Jan 17, 2020 ... I am trying to take a value from a cell in a particular tab in a spreadsheet, and then compare text on a sub-string of that cell, and then mark a box ...
FIND function - Google Docs Editors Help
https://support.google.com/docs/answer/3094126?hl=en : Divides text around a specified character or string, and puts each fragment into a separate cell in the row. SEARCH : Returns the position at which a ...
Find and Replace - finds the string but when I want it replaced it says ...
https://support.google.com/docs/thread/39815474/find-and-replace-finds-the-string-but-when-i-want-it-replaced-it-says-that-it-can-t-find-the-strin?hl=en Apr 13, 2020 ... So, this sheet had formulas in every cell. What I just did was take the parsed sheet and copy and paste the VALUES ONLY into a 3rd sheet in the ...
How do I search across multiple columns for a partial string of text ...
https://support.google.com/docs/thread/121705592/how-do-i-search-across-multiple-columns-for-a-partial-string-of-text?hl=en Aug 17, 2021 ... Without ARRAYFORMULA, the sheet will only look at the first cell of the formula. Also, if you add the $ or static symbol to the cell ...
Conditional formatting, highlight row if cell contains substring ...
https://support.google.com/docs/thread/7025381/conditional-formatting-highlight-row-if-cell-contains-substring?hl=en May 29, 2019 ... The OR function worked well. However, for the Search one, I want to be able to highlight an entire row if a cell contained the word "Apple ...
In Google Sheets search not finding text string - Google Docs Editors ...
https://support.google.com/docs/thread/135148108/in-google-sheets-search-not-finding-text-string?hl=en Nov 12, 2021 ... When I search via Find and Replace in Google Sheets for a text string (no formula used to generate the text string) the highlighted cell supposedly where the ...
Return a Value based on Substring Match of an Array - Google Docs ...
https://support.google.com/docs/thread/132454747/return-a-value-based-on-substring-match-of-an-array?hl=en Oct 25, 2021 ... I wasn't sure if I can use the MATCH function to search substrings and I'm not super versed in the QUERY function yet. Hopefully that makes ...
Count number of occurrences of a string within a cell - Google Docs ...
https://support.google.com/docs/thread/66532343/count-number-of-occurrences-of-a-string-within-a-cell?hl=en Aug 23, 2020 ... =ArrayFormula(SUM(IFERROR(FIND(B$1,MID($A2,SEQUENCE(LEN($A2),1,1,1),50))=1)*1)). where A2 was the Full text (KYYYGGGRYYROGGGRROOYYGGGOOORK) ...
how to determine whether a cell contains a formula
https://groups.google.com/g/exceldna/c/87Qi8Q5sVq4 Oct 5, 2010 ... public static string nDescribe([ExcelArgument(AllowReference=true)]object arg) { if (arg is ExcelReference) { ExcelReference cell ...
Conditional formatting based on partial string match, from a list of ...
https://support.google.com/docs/thread/163298018/conditional-formatting-based-on-partial-string-match-from-a-list-of-strings-in-separate-cells?hl=en May 11, 2022 ... I want the cells in column A to behave so that when any of the strings from each cell in column D have an exact or partial match with the string in column A.. ...
Extracting multiple occurrences from a single cell - RegexReplace ...
https://support.google.com/docs/thread/67377264/extracting-multiple-occurrences-from-a-single-cell-regexreplace-substitute-find-replace?hl=en Aug 27, 2020 ... Part of that formula does a count of how many times the pattern is matched. That count is then used with join to make a string used with ...
is there a formula to check if a cell contains certain text? - Google ...
https://support.google.com/docs/thread/296695635/is-there-a-formula-to-check-if-a-cell-contains-certain-text?hl=en Sep 14, 2024 ... The cell to test may contain variations of "Fix ...";. the result will all return the same value, so instead of entering each of many iterations ...
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]), Returns a cell reference as a string. Learn more ... search row or column. Learn more.
How can I search in a cell for a word in a sentence, and if it find it ...
https://support.google.com/docs/thread/147050478/how-can-i-search-in-a-cell-for-a-word-in-a-sentence-and-if-it-find-it-then-write-a-certain-word?hl=en Jan 21, 2022 ... So if it search and finds "Pencil" then I want it to write a certain word, for example: "Yes there is a pencil". Is that posible? What formula ...
Formula to return matching value from list for a string of text - Google ...
https://support.google.com/docs/thread/135881852/formula-to-return-matching-value-from-list-for-a-string-of-text?hl=en Nov 17, 2021 ... I need to match a string a texts (column A) to a list of values ... I added the Tab title tab and entered my formula in cell D1 in the first tab ...
Index Match Multiple Criteria W/ Partial String Match & Value Match ...
https://support.google.com/docs/thread/145364829/index-match-multiple-criteria-w-partial-string-match-value-match?hl=en Jan 12, 2022 ... ... formula. - I would also like to to match an exact value -- eg: CELL=COLUMN. I have tried to following formula (on sheet below -- cell I2 ...
SUBSTITUTE - Google Docs Editors Help
https://support.google.com/docs/answer/3094215?hl=en SUBSTITUTE. Replaces existing text with new text in a string. Sample Usage. SUBSTITUTE("search for it"," ...
How to SUBSTITUTE cells with other values ONLY when the ...
https://support.google.com/docs/thread/60109727/how-to-substitute-cells-with-other-values-only-when-the-replacement-matches-entire-cell-content?hl=en Jul 20, 2020 ... At the moment, my formula is replacing part of the string that matches the replacement text. ... The formula in the green cell is exactly what I ...
How to search and extract a single value from a comma separated ...
https://support.google.com/docs/thread/96850498/how-to-search-and-extract-a-single-value-from-a-comma-separated-string-into-another-cell?hl=en Feb 5, 2021 ... ... search and extract a single value from a comma separated string into another cell. ... ARRAYFORMULA so it will calculate for the entire column ...
How to Parse the Excel Formula using Excel DNA
https://groups.google.com/g/exceldna/c/dqq2HHcT2KE Feb 17, 2016 ... (i.e) string currentFormula = Globals.ThisAddIn.Application.Range[cellIndex].Formula. For example : If a Active Cell contains the formula,.