About 1,393,720 results (3,119 milliseconds)
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 ... In my example sheet, I'd like to search the string in column B for any of the substrings in column E. If there is a match, ...
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.
Finding the cell reference using ExcelDna
https://groups.google.com/g/exceldna/c/iQ-W6uGmeRE May 15, 2007 ... I recently asked Govert how to find an excel cell reference in ... string sheetName = (string)XlCall.Excel(XlCall.xlSheetNm, reference);
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 ... I am trying to delete all occurrences of corporation designations like "INC" and "LLC" in a column of cells that contain company names.
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 ... I have tried selecting the column that contains the text, a Ctrl-A ... Is Google Sheets a 32-bit utility – in the past when using 32-bit Excel ...
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.. ...
Unsure how to import Excel file with all columns
https://groups.google.com/g/cytoscape-helpdesk/c/LA6s1S7fPg4/m/eHONlk3EAAAJ Nov 1, 2020 ... The STRING network will load with its own node names, but there will be a column called “query term” that will match the names you used. 2. Data ...
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 ... assuming your data is in column A. =LEFT(A2,FIND(" ",A2)-1) -- Best Regards,. Luke M *Remember to click " ...
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 ... That will highlight the entire row if either condition is true. For the first one, try this: =SEARCH("Green Apples",$C2). Or ...
search coordinates of the current cell
https://groups.google.com/g/openpyxl-users/c/nGrKiW4RUkw I have a dictionary whose key is a string of 2 characters, and whose value is an amount. Using an Excel sheet from a sample workbook, I'd like to find the cell ...
counting occurrences of a string in excel file, using python?
https://groups.google.com/g/python-excel/c/NcYKju_5DY8 Aug 30, 2011 ... to python-excel.. The following code will work, assuming that each cell contains an entire string that you need to search for: book = xlrd ...
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 ...
Newbie: Difference between two dates stored in two columns
https://groups.google.com/g/openrefine/c/krmtMiZW_Pc Nov 5, 2016 ... ... excel, however the way I am working, it would be nice to get a finished table out of OpenRefine). What I tried was to get the diff ...
How to Find and Replace a text in a column - Google Docs Editors ...
https://support.google.com/docs/thread/266384787/how-to-find-and-replace-a-text-in-a-column?hl=en Mar 28, 2024 ... Now if your looking to replace phrases in a text string that would be different. Does this work for you?
REGEXMATCH string against column/range of data - Google Docs ...
https://support.google.com/docs/thread/159773469/regexmatch-string-against-column-range-of-data?hl=en Apr 13, 2022 ... I'm trying to use REGEXMATCH to search a single column of cells. The formula works fine enough on a single cell, but when extended beyond just one it returns a ...
If string contains text from list, write matched text to cell - Google ...
https://support.google.com/docs/thread/23160947/if-string-contains-text-from-list-write-matched-text-to-cell?hl=en Dec 17, 2019 ... I'm working on a large Google spreadsheet with key phrases, strings of text, in column A. I want to search column A based on a list of keywords that live in ...
Find and replace across multiple columns
https://groups.google.com/g/openrefine/c/0dx1ciZpetI Apr 4, 2017 ... I`m using a two step workflow using Regex to find, replace and delete text after a certain character in each column. ... excel called Regex Find ...
Replacing empty cells via Find and Replace not working - Google ...
https://support.google.com/docs/thread/217248400/replacing-empty-cells-via-find-and-replace-not-working?hl=en May 23, 2023 ... Your regex ^(\s*)$ will find cells that contain white space, or that have at least at one point contained a text string but are now empty. That ...
sumproduct - find text in string
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/1WVygPPKxaU Feb 22, 2010 ... Some cells have text ... I am using Excel 2003 and I have two columns with data on resources. Column F is the role name and Column H contains ...
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 ...