check substring of a string in Excel VBA

's Computer Specifications

Hi,

How do I check the subtring of a string ? I don't think I can use Strcomp.

Let say I have string "Hello world"

The Substring that I want to find is "orl"

What function can I use?

Regards,
Magix

's Computer Specifications

Checkout the InStr() function in Help.
--
Gary's Student

"magix" wrote:

> Hi,
>
> How do I check the subtring of a string ? I don't think I can use Strcomp.
>
> Let say I have string "Hello world"
>
> The Substring that I want to find is "orl"
>
> What function can I use?
>
> Regards,
> Magix
>
>
>

's Computer Specifications

Or if you just want to know if the string contains "orl", use

MsgBox "Hello World" Like "*orl*"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Gary''s Student" <(E-Mail Removed)> wrote in message
news:A92AD686-FECB-4F15-AC07-(E-Mail Removed)...
> Checkout the InStr() function in Help.
> --
> Gary's Student
>
>
> "magix" wrote:
>
> > Hi,
> >
> > How do I check the subtring of a string ? I don't think I can use
Strcomp.
> >
> > Let say I have string "Hello world"
> >
> > The Substring that I want to find is "orl"
> >
> > What function can I use?
> >
> > Regards,
> > Magix
> >
> >
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
String Manipulation - Substring, VB function Left, "length safe" Substring	kellygreer1	Microsoft C# .NET	6	29th Oct 2006 08:12 PM
How to get rid of string which contain a substring like 'PO BOX'.	dukejas	Microsoft Excel Programming	2	11th Nov 2003 03:37 AM
String.Remove vs String.Substring	Janaka	Microsoft Dot NET Framework	2	5th Nov 2003 02:59 PM
check if string contain substring	Ivan Demkovitch	Microsoft C# .NET	3	22nd Oct 2003 06:17 PM
string function that finds substring within string	vaughn	Microsoft C# .NET	2	4th Oct 2003 12:01 PM