[Solved] VBA: Is a particular text string contained in this

tvsmvp · Sep 27th 2003

I know this has gotta be one of those "d'uh!"-type questions... but what's the simplest way to find out if a character or string of characters is contained in a cell? (in this case I'm testing the selected cell to see if ";" is present)

Anonymous · Sep 27th 2003

=Find(";",A1)
will return the first position of ; in cell A1 if it is in the cell. and #Value if it is not.

tvsmvp · Sep 27th 2003

So then I would write the code to, in essence, tell me "false" if your code returns an error?

Barrie Davidson · Sep 27th 2003

Code

If InStr(Range("A1"), ";") &gt; 0 Then
    'it's found
Else
    'it's not found
End If

Regards,

Anonymous · Sep 27th 2003

Ah, I was too quick in my reply and didn't read VBA in the title. To clarify, FIND works as stated in a worksheet. INSTR works as Barrie says in VBA.

tvsmvp · Sep 28th 2003

This works like a charm, guys - many thanks!

[Solved] VBA: Is a particular text string contained in this

Participate now!

Share