Results 1 to 9 of 9

How to limit multi-value (OR) FIND or SEARCH to the first or last word in a string?

Threaded View

Buzzed Aldrin How to limit multi-value (OR)... 07-13-2012, 07:44 PM
tlafferty Re: How to limit FIND or... 07-13-2012, 07:59 PM
tlafferty Re: How to limit FIND or... 07-13-2012, 08:02 PM
protonLeah Re: How to limit FIND or... 07-13-2012, 08:22 PM
olasa Re: How to limit FIND or... 07-13-2012, 09:20 PM
Buzzed Aldrin Re: How to limit FIND or... 07-14-2012, 01:51 PM
protonLeah Re: How to limit multi-value... 07-14-2012, 02:31 PM
jason.b75 Re: How to limit multi-value... 07-14-2012, 03:55 PM
Buzzed Aldrin Re: How to limit multi-value... 07-16-2012, 04:05 PM
  1. #1
    Registered User
    Join Date
    02-04-2012
    Location
    CA, USA
    MS-Off Ver
    Excel 2010
    Posts
    56

    How to limit multi-value (OR) FIND or SEARCH to the first or last word in a string?

    Hi all,

    Can a FIND or SEARCH formula be limited to detect multiple 'OR' values only if the values are the first or last in a string? (I don't need a single formula that checks for both conditions; I can use 2 formulas if it's significantly easier).

    For example, can =OR(ISNUMBER(SEARCH({"dog","mouse","elephant"},A1))) be modified to detect "Dog 123" or "Mouse123 ABC" or "123 XYZ Elephant" while ignoring cells containing any of the values in an intermediate position?

    Thanks for any help!
    Last edited by Buzzed Aldrin; 07-14-2012 at 01:45 PM. Reason: Wrong initial problem statement

Thread Information

Users Browsing this Thread

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

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