search strings

  1. D

    String "TEMAN" is not recognized in namedrange for SEARCH command?

    Hi Excel Experts, I came across very weird situation here. Hopefully, somebody can give me solution. I'm trying to create a formula that will search the string(s) in a namedrange and return "Yes" if one of them matches in the sentence of the referred cell and return "" if no match. However, I...
  2. G

    HELP with search in strings

    Hey all, I have URL strings such as: url/Live-to-Ride-Long-Sleeve-T-Shirt-5223/ url/Live-To-Ride-Motorcycle-Long-Sleeve-T-Shirt-4963/ url/Live-To-Ride-Motorcycle-T-Shirt-4964/ url/Live-To-Ride-Motorcycle-Women-T-Shirt-4965/ url/Live-To-Ride-Motorcycle-Women-T-Shirt-6096/...
  3. T

    Search entire row for string

    I'm wanting to search two columns for the string in TextBoxSearchItemList.text. then put these values into another list position. as you can see here ive made a raw idea of what im trying to do but i think im trying the wrong method. any help would be appreciated. Ive tried to search for...
  4. K

    Need to return multiple values based upon multiple criteria

    I'm not sure if Excel or Access is the best tool. I am seeking to search for roughly 1,000 unique search strings amongst 100,000 customers and identify all string matches. The customer data set consists of customer ID (column A) and customer name (column B). I would like to return all...
  5. A

    macro to search with two criteria

    Hi friends, I have big problem, please help me. I am new in excel vba and I am learning. This is the problem: I have sheet like this: <TABLE class=MsoNormalTable style="MARGIN: auto auto auto 4.8pt; WIDTH: 145.5pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm...
  6. J

    Elegant Solution for Searching for Multiple Strings in Multiple Cells using NAME?

    Hi everyone - I currently have a working Excel Workbook that I am using to search multiple cells for an array of strings. I have condensed the strings in the array for purposes of posting on this site (there are dozens of strings to search for). Ideally, I'd like to put all the text in the...
  7. C

    Search a string within a sheet

    Hello! Probably an easy one for you guys... I have a table of data and i need to search the table for 8digit numbers, that are beginning with "2" and copy the numbers to the column on the right. A cell can contain multiple numbers with 8 digits. Thanks in advance.
  8. I

    Create new data column from 2 different word lists

    Hi, let's say I have data in columns A-B, and a target list in C: A B C dog 21 dog cat 43 mouse mouse 21 lion puppy 45 lion 23 What I need is a way to...

Some videos you may like

This Week's Hot Topics