partial text

I'm looking to build a formula with a series of nested IF(AND statements where one of the two conditions in each IF statement looks for a certain portion of a text in a cell. For example if A1 contains "44 White Birds", and A2 contains "Willow Tree" I need cell A10 to look for "44W" in A1, and...

Hi to all Is it possible to color a partial text in cell when text is a result of formula (not text written directly in cell)? I know it not possible by Conditional formatting, but maybe by VBA code... 1. I want to colorize name and symbol "!" that comes after name (when symbol appear) to Red...

Hi, I am trying to make a label visible/invisible depending on the partial value of a textbox in a userform. So the text box will contain lots of different text but if it contains Top of the card or bottom of the card etc then i want te label to be visible otherwise i want the label to be...

I need your help in getting the right formula for this. In column B, I have a list of items called Support Type. There're just 2 types, 535 and 532. These are taken over from a larger table with a formula. Column D lists the Employee Names. Also taken over from another table with a formula...

How would you set up advanced filter if you want to collect records of a dataset that contain numbers stored as text, and you want them starting with the partial text 646&"*" or 647&"*". I have a dataset where a column contains account code in text format such 6****** and I want all of those...

Hello, I am having trouble with this as I would like to use Advanced Filter using NOT criteria for partial text. I have customer names in Column A and Revenue in Column B. The customer names contain various store name and numbers so I would like to filter out customers that don't contain the...

I have two arrays. Array A has a list of multiple terms in a column such as this: <tbody> Urinary Bladder Cancer|Bladder Tumors|Transitional Cell Carcinoma of the Bladder|Malignant Melanoma|Melanoma|Skin Cancer|Carcinoma, Non-Small-Cell Lung|Lung Cancer Platinum Sensitive Ovarian...

Ok... so I have a simple piece of code that works fine. Basically it is checking the ActiveCell to see if any part of the cell contains the word "Cat" and if it does, it returns "True" in the cell one column to the right. 'Checks the activecell value to see if any part of the cell contains the...

In excel work book one, I have account codes that look like this. <tbody> 00-1-110-31011 00-1-110-31031 00-1-110-31042 </tbody> This account code occupies one cell and is followed by a $ value in the next adjacent cell. In excel work book two, I have account codes that look like this...

OK... so here's what I need that I can't figure out. Below in Column A is a list of Students with their teacher's name. In column G is a list of Teacher's names for this worksheet. In H2, I have a counta formula which tells me the number of teachers for this grade. I need a macro that will...

I am trying to write a formula that will look at the contents of a cell (D19) and see if it contains the text "R-". If D19 contains "R-", then value of D21 for which I am writing the formula would be "240V 1-phase". If D19 doesn't contain "R-", then the value in D21 would be "460V 1-phase"...

Hi, I have a list (1) of first in last names, and a list (2) of just first names. I want to be able to find whether a cell in list 1 contains one of the first names in list 2. Example List 1: John S (N/A) Matt K (yes) Eric F (yes) Mary Y (N/A) List 2: Zack Matt Amy Eric

Hello, Would really appreciate your kind help here...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have 2 lists of customer names (from 2 different systems) as a result I have multiple names for the same customer. (even in the same list)<o:p></o:p> So...

Ok, so I am trying to search for a name from one cell in a column on another spreadsheet. They are not exact matches because one spreadsheet has the middle initial and the other doesn't. So trying to search a column another spreadsheet for partial text in one cell and return "yes" if it's...

How do you write a macro, script or conditional formatting (or is there an add-in I can buy) that will use a partial text match from cells in one column (column J), to filter the list of phrases in another column (Column A). I found a formula that lets me filter column A by just one cell in...