Results 1 to 2 of 2

Thread: search in cells to find any instance of words

  1. Aug 9th, 2006, 02:52 PM #1
    heinz1218
    heinz1218 is offline

    Thread Starter
    Member
    Join Date
    Jul 2006
    Posts
    41

    search in cells to find any instance of words

    I'm trying to search through a list of company names which include universities and states. I want to eliminate any instance of the word "university" or "state of", regardless of where it occurs in the cell. How would I go about doing that?
    Reply With Quote Reply With Quote
  2. Aug 9th, 2006, 03:34 PM #2
    zaza
    zaza is offline
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: search in cells to find any instance of words

    Use the Find method (shown in my Excel Tips and Tricks link) using the argument LookAt:=xlPart to do the search, then just use Replace or Instr to rewrite teh string. Then use FindNext (see VBA Help) to keep searching...


    zaza
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width