About 1,762,784 results (3,392 milliseconds)
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 ...
FIND function - Google Docs Editors Help
https://support.google.com/docs/answer/3094126?hl=en SPLIT : 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 ...
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 ...
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 ... Find and replace won't work because it is always referencing the text in a cell not the formula, in this case it is a specific cell. Find and ...
sumproduct - find text in string
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/1WVygPPKxaU Feb 22, 2010 ... “non commission” appears within text entered into cell H150 ... > I tried to write a sumproduct formula to find various text within a range > ...
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 ... If the text does not contain 'pencil', an error will be returned. You can use IF() to create a logical decision on what the formula should do if ...
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Encodes a string of text for the purpose of using in a URL query. Learn more. Web, HYPERLINK, HYPERLINK(url, [link_label]), Creates a hyperlink inside a cell.
Cell formula to display different text based off text in another cell ...
https://support.google.com/docs/thread/158958439/cell-formula-to-display-different-text-based-off-text-in-another-cell?hl=en Apr 7, 2022 ... Bear with me for a bit as I'm finding it hard to explain what I am trying to achieve. Pretty much I have a google sheet which I update every ...
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 ...
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"," ...
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 ...
Formula to pull first word from text string in a column
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/6mpla5aAVFU Jan 8, 2009 ... Microsoft Excel MVP. "David Biddulph" <groups [at] biddulph ... That formula will return an error because FIND can't find a space character
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 ... Copy and paste with cleanup will be my only option, working with a single long string of text that includes a list of individual names, numbered ...
Find partial text in a table and then return another value - Google ...
https://support.google.com/docs/thread/44387963/find-partial-text-in-a-table-and-then-return-another-value?hl=en May 4, 2020 ... In below sheet, I want to see if cell F2 (budget-sheet) contains any partial text string ... In excel I used lookup and search (see formula in ...
Where is the list of functions that are built-in to the macro language. I ...
https://support.google.com/docs/thread/11585560/where-is-the-list-of-functions-that-are-built-in-to-the-macro-language-i-have-searched-google?hl=en Aug 9, 2019 ... I have done this in other languages (and especially in VBA for Excel) to process text strings which have odd delimiters. ... Using cell formulae I ...
Search and use find and replace - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/62754?hl=en&co=GENIE.Platform%3DDesktop Search using regular expressions: Searches for cells that match a pattern. Also search within formulas: Searches include formulas. To replace the highlighted ...
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 ... How to search and extract a single value from a comma separated string into another cell. I have a column with comma separated text values I ...
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 ...
Trying to count multiple occurrences of a list of word inside a single ...
https://support.google.com/docs/thread/107603040/trying-to-count-multiple-occurrences-of-a-list-of-word-inside-a-single-cell?hl=en Apr 26, 2021 ... ... string, and also get the true count of instances inside a cell. ... find the formula I came up with in cell B2. https://docs.google.com ...
How to extract a text result by searching a cell separated by commas ...
https://support.google.com/docs/thread/102780221/how-to-extract-a-text-result-by-searching-a-cell-separated-by-commas-for-a-text-starting-with?hl=en Mar 18, 2021 ... Here is an example cell string (from column V):. Color: Navy Blue ... The rest of the categories are all the same formula just with the keyword(s) ...