Excel Magic Trick 321: Match Text Substrings

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
2,994
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on May 8, 2009

See how to Match All Text Substrings with an array formula that uses the AND ISNUMBER and SEARCH functions.

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • hey i have a names column and i would like to have a search box to find the result i entered, what is the best video to watch for that, or what formula do you think i should use?

  • If the columns are named with Defined Names, just use the Name box to select and go to the defined names.

see all

All Comments (3)

Sign In or Sign Up now to post a comment!
  • awesome

    

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more