Results 1 to 7 of 7

If a cell contains two specific groups of text, then put a specified text in another cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    St. Louis, MO
    MS-Off Ver
    Excel 2007
    Posts
    5

    If a cell contains two specific groups of text, then put a specified text in another cell

    I need a formula so that if it finds two specified groups of text in a cell (say cell A1) then it would put a specified text in another cell (say cell A2).

    For example, the contents of cell A1 is "1RXXXLPXX". Since "1R" and "LP" are in cell A1, I need it to put a specific word in cell A2.

    I know how to make it find just "1R" in cell A1 and put a word in cell A2 - I'm using:

    =IF(ISNUMBER(SEARCH("1R",$C56)),"1R")

    But I don't know how to make it find "1R" AND "LP".



    Any help would be appreciated!!
    Last edited by FDibbins; 10-19-2012 at 06:01 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1