Checking to see whether a string contains a certain character

  • Thread starter Thread starter ajitpalsingh200
  • Start date Start date
A

ajitpalsingh200

Is there any way to check whether string "chair" contains "*" or not?

thankx in advance
 
Use function InStr():

InStr(1, "chair", "*") returns 0 bcause * isn't found in "chair";
InStr(1, "chair", "h") returns 2, because h is found in the second position
in "chair" starting from 1.

HTH,
Nikos
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to write a VBA code to check whether TCP port (e.g.3306) isblocked or not? 5
Checking whether a worksheet exist or not 4
check if a string contains a particular character 3
Checking for special characters in a string 1
Test for NULL string? 3
Excel VBA 0
Check whether URL exists 1
How to check if a certain function is used 2

Back
Top