Jan 18, 2024 · That is, if a cell contains some text, then return something, if it contains another text, then return something else, and so on. To evaluate multiple conditions in a cell, you can use nested "if cell …

Sep 4, 2013 · Is there an in-built function to check if a cell contains a given character/substring? It would mean you can apply textual functions like Left/Right/Mid on a conditional basis without throwing e...

Jan 16, 2020 · I've seen many posts about the subject, but in general the question has been to return the value of a cell if the cell contains text from a list. I have used the following formula for that: =IF(OR(

Feb 23, 2012 · 3 I want to check a range of cells for a certain piece of text. This text is always in my document, except it's cell is variable (column is always B). So I check a range from 1:75 whether any …

Jan 27, 2024 · 0 I have used a filter formula and I want to make a column that shows checkboxes for every row that contains text from the filter formula result I used this formula =FILTER …

May 20, 2025 · Checking if cell contains one (or multiple) of several exact values in Excel Asked 6 months ago Modified 6 months ago Viewed 126 times

Dec 19, 2022 · I am trying to come up with a way to delete all rows (and shift cells up, if possible) where the website column cell contains the word none. The table contains 5000+ records and this would …

Apr 1, 2017 · So what function would be the best then for retuning a Boolean True/False value based on cells contains the specified string? I would like to be able to have all of these True/False values next …

Jan 22, 2021 · My idea was to get an alert every time I digit the word "high" in a cell of column A (also if the word is contained in a longer string). This alert should pop up just if i edit a cell …

Mar 4, 2021 · I know it's a recurring topic but I need please your help because my VBA code is not working I am trying to create a loop on cell value who contain a special text inside the column (B:B): …