| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup part of string... | Excel Discussion (Misc queries) | |||
| Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
| How do I use VLOOKUP to find part of string? | Excel Worksheet Functions | |||
| Find and replace part of a text string | Excel Discussion (Misc queries) | |||
| Extract Part of String | Excel Worksheet Functions | |||
Linear Mode
