Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
this piece of code give a wrong answer ? Test Dec 05 SFE NSW Base if Strcomp(Test,"Feb") = true then ? "True" Else ? "Not" True if Strcomp(Test,"ASX") = true then ? "True" Else ? "Not" Not The word 'Feb' is not in the string but it returns a true answer. If you try the word 'ASX' it returns false. WHY and how do you fix it Thanks MarkS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Searching for a string of text inside a column | Excel Worksheet Functions | |||
Find String in another string - only between spaces | Excel Worksheet Functions | |||
Find Many String options in ONE String | Excel Worksheet Functions | |||
Check if a String is inside an Array | Excel Programming | |||
Check if a String is inside an Array | Excel Programming |