Substring in excel? How about regular expressions?

Giganews Newsgroups
Subject: Substring in excel? How about regular expressions?
Posted by:  Samuel (stwils…@writeme.com)
Date: 22 May 2006

I need to act upon the test "USA" found in the first three chars of a
cell.
This is what I did, but I get a compile error..
So I did something wrong. How do I copare against specifc characters?
Even better, can I use regular expressions?

  str = ActiveSheet.Cells(r, c)
  check = substr(str, 1, 3)
  If (check = "USA") Then
      ' do something
  End If

Replies