About 1,455,756 results (1,959 milliseconds)
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 ... Create a formula that will search across multiple columns and look for a partial string of text and indicate either yes or no that that text is there.
Query function - find multiple names from one column in another ...
https://support.google.com/docs/thread/101461031/query-function-find-multiple-names-from-one-column-in-another?hl=en Mar 9, 2021 ... I want to find all the names in one column where the appear in another, together with their corresponding scores, limited to 4.
Using multiple filters of "Text does not contain" - Google Docs ...
https://support.google.com/docs/thread/8668649/using-multiple-filters-of-text-does-not-contain?hl=en Jun 25, 2019 ... The idea is to filter the search terms found on sheet 1 based on the filters in sheet 2. if a search term consists of any of the filters terms it should not be ...
Using find in Google Sheets to find cells containing multiple words ...
https://support.google.com/docs/thread/139358037/using-find-in-google-sheets-to-find-cells-containing-multiple-words?hl=en Dec 8, 2021 ... Insert > Sheet, put the search words in cells in some range in the first rows of the new sheet, and use a formula to build a regex of those ...
Trying to use the "find" option to highlight multiple cells - Google ...
https://support.google.com/docs/thread/147019035/trying-to-use-the-find-option-to-highlight-multiple-cells?hl=en Jan 21, 2022 ... When the filter icons appear in the column headers, select one to apply a filter. You can filter by color (fill or text), condition (is empty, ...
How can I search a column for multiple keywords or sentences ...
https://support.google.com/docs/thread/25609101/how-can-i-search-a-column-for-multiple-keywords-or-sentences?hl=en Jan 14, 2020 ... I want to analyze the rule text of Magic cards for certain keywords or sentences in order to atribute them to a certain category.
Is there a way to make rows with multiple lines of text only show a ...
https://support.google.com/docs/thread/240451229/is-there-a-way-to-make-rows-with-multiple-lines-of-text-only-show-a-single-line-of-text?hl=en Oct 23, 2023 ... ... text in each cell, and then when someone wants to view the comments they can expand it out full to view all the text? The only other option ...
Conditional Formatting to Highlight Cells Based on Multiple Values ...
https://support.google.com/docs/thread/270172798/conditional-formatting-to-highlight-cells-based-on-multiple-values?hl=en Apr 19, 2024 ... All of these values contain the words 'director' AND 'marketing' but the 'TEXT CONTAINS' conditional formatting rule would not capture them all ...
Multiple Links in One Google Sheets Cell - Google Workspace ...
https://support.google.com/a/thread/45130142/multiple-links-in-one-google-sheets-cell?hl=en May 8, 2020 ... If two of the words you are trying to assign links to are directly adjacent to one another, when you click to add the second link, it sometimes ...
Find and replace across multiple columns
https://groups.google.com/g/openrefine/c/0dx1ciZpetI Apr 4, 2017 ... ... excel called Regex Find and Replace. ... Of course, a simple search & replace can be done in a spreadsheet - or even in a text editor if the file ...
How to find in all sheets instantly like Ctrl-f. - Google Docs Editors ...
https://support.google.com/docs/thread/139431694/how-to-find-in-all-sheets-instantly-like-ctrl-f?hl=en Dec 8, 2021 ... I have a number of sheets full of domain names (URLs) in excel. And I approach those sites that we did not approach yet. So I search to the ...
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 ... Extracting multiple occurrences from a single cell - RegexReplace / Substitute / FInd & Replace ... text that includes a list of individual ...
I want to center text across multiple columns - Google Docs Editors ...
https://support.google.com/docs/thread/218416562/i-want-to-center-text-across-multiple-columns?hl=en May 30, 2023 ... Looked through Help and can't find it... Details. Sheets,Microsoft ... There is no Center Across feature as I believe there is in Excel.
How to QUERY/INDEX+MATCH multiple rows of text from a merged ...
https://support.google.com/docs/thread/11089976/how-to-query-index-match-multiple-rows-of-text-from-a-merged-cell?hl=en Aug 1, 2019 ... I've been trying multiple methods of using VLOOKUP, INDEX+MATCH, and QUERY to output 2-3 rows of information based on a drop-down merged cell.
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 ... At the moment, it can only search and count single words or strings (sleeping, baby, co-sleep, etc.), but how about something like "co sleeping" ...
Find and replace: change part of the text in multiple cells - Google ...
https://support.google.com/docs/thread/188752779/find-and-replace-change-part-of-the-text-in-multiple-cells?hl=en Nov 15, 2022 ... I have a Google Sheets document with thousands of rows containing music-related data (artists, tracklists, etc.). I want to change all artist names that end ...
In a pivot table, trying to add multiple filter conditions to the same ...
https://support.google.com/docs/thread/114854157/in-a-pivot-table-trying-to-add-multiple-filter-conditions-to-the-same-category?hl=en Jun 25, 2021 ... Original Poster Google user marked this as an answer. Helpful? 9. Upvote. Downvote. View conversation. All Replies (4). Prashanth K V. Diamond ...
How to use find+replace to replace newline (\n) with soft linebreak or ...
https://support.google.com/docs/thread/9648924/how-to-use-find-replace-to-replace-newline-n-with-soft-linebreak-or-vertical-tab-v?hl=en Jul 10, 2019 ... I am importing text from Unix and MacOS into Google Docs document and the text ... You can copy it to MS Word, do an efficient multiple find- ...
Quickest way to search multiple rows/columns at once for a single ...
https://support.google.com/docs/thread/208630346/quickest-way-to-search-multiple-rows-columns-at-once-for-a-single-true-false-match?hl=en Mar 30, 2023 ... The quickest way to search multiple rows/columns at once for a single true/false match is to use the FILTER function.
Having multiple values in one cell - Google Docs Editors Community
https://support.google.com/docs/thread/265682904/having-multiple-values-in-one-cell?hl=en Mar 24, 2024 ... However if I were to add farm to study on the first day for example, how can I edit or use formulas so that the COUNTIF can read both texts as ...