Find a part of a string
 

Hallo

I would like to check a string e.g C:\Windows\Ger\Test.xls" of Ger is in
that string?

Excuses for the bad Englisch

Thanks

Peter

Find a part of a string
 

In VBA you can use InStr. In Excel you can use Find. Both functions return
the starting point of one string within the other . If the string is not
found then thye return 0.

HTH

"Peter Pantus" wrote:

Hallo

I would like to check a string e.g C:\Windows\Ger\Test.xls" of Ger is in
that string?

Excuses for the bad Englisch

Thanks

Peter

Find a part of a string
 

Just to add:
reference using Find in a worksheet; Find is case sensitive. Search is
identical to Find, but is case insensitive.

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in message
...
In VBA you can use InStr. In Excel you can use Find. Both functions return
the starting point of one string within the other . If the string is not
found then thye return 0.

HTH

"Peter Pantus" wrote:

Hallo

I would like to check a string e.g C:\Windows\Ger\Test.xls" of Ger is in
that string?

Excuses for the bad Englisch

Thanks

Peter

Find a part of a string
 

Good Point... :)

"Tom Ogilvy" wrote:

Just to add:
reference using Find in a worksheet; Find is case sensitive. Search is
identical to Find, but is case insensitive.

--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in message
...
In VBA you can use InStr. In Excel you can use Find. Both functions return
the starting point of one string within the other . If the string is not
found then thye return 0.

HTH

"Peter Pantus" wrote:

Hallo

I would like to check a string e.g C:\Windows\Ger\Test.xls" of Ger is in
that string?

Excuses for the bad Englisch

Thanks

Peter