Check if a string contains another string

Use the Instr function

Dim pos As Integer

pos = InStr("find the comma, in the string", ",")

will return 15 in pos

If not found it will return 0

If you need to find the comma with an excel formula you can use the =FIND(",";A1) function.

Notice that if you want to use Instr to find the position of a string case-insensitive use the third parameter of Instr and give it the const vbTextCompare (or just 1 for die-hards).

Dim posOf_A As Integer

posOf_A = InStr(1, "find the comma, in the string", "A", vbTextCompare)

will give you a value of 14.

Note that you have to specify the start position in this case as stated in the specification I linked: The start argument is required if compare is specified.

Related Posts:

  1. What does <> mean?
  2. How to find a value in an excel column by vba code Cells.Find
  3. VBScript to open a dialog to select a filepath
  4. Does VBA have Dictionary Structure?
  5. “Sub or Function not defined” when trying to run a VBA script in Outlook
  6. What is the function of FormulaR1C1?
  7. What exactly is the function of Application.CutCopyMode property in Excel
  8. VBA Excel – Insert row below with same format including borders and frames
  9. Deleting a file in VBA
  10. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  11. How to comment and uncomment blocks of code in the Office VBA Editor
  12. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  13. Pass arguments to Constructor in VBA
  14. How to install Date Picker form control in Excel 2016
  15. How to install Date Picker form control in Excel 2016
  16. How to fill color in a cell in VBA?
  17. Refreshing all the pivot tables in my excel workbook with a macro
  18. VBA: Run time error ’91’?
  19. Compare Dates in VBA
  20. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  21. ‘Cannot find DAO350.dll’ file error VB6
  22. Average in VBA in Excel
  23. VBA Excel “Compile error: Object Required”
  24. Choosing paper size (NOT DEFAULT sizes) in excel vba
  25. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  26. Paste Special error 1004 PasteSpecial method of Range class failed
  27. VBA: Getting run-time 1004: Method ‘Range’ of object ‘_Worksheet’ failed when using cells
  28. Cannot run the macro… the macro may not be available in this workbook
  29. How do I lowercase a string in Python?
  30. Why the switch statement cannot be applied on strings?
  31. How does strtok() split the string into tokens in C?
  32. How to read a file line-by-line into a list?
  33. How to convert string to char array in C++?
  34. How can I convert a std::string to int?
  35. Check if a string has a certain piece of text [duplicate]
  36. How can I convert String to Int?
  37. How to convert a string to an integer in JavaScript?
  38. How to convert string to char array in C++?
  39. How to convert an int to string in C?
  40. C++ string to double conversion
  41. How do I make the first letter of a string uppercase in JavaScript?
  42. Regex not operator
  43. Reverse a string in Java
  44. Best way to convert string to bytes in Python 3?
  45. How to check if a String contains another String in a case insensitive manner in Java?
  46. Split string into array
  47. How to replace � in a string
  48. How to print like printf in Python3?
  49. Convert int to string?
  50. Multi-line string with extra space (preserved indentation)
  51. How to find all occurrences of a substring?
  52. How to reverse an std::string? [duplicate]
  53. How to split a delimited string into an array in awk?
  54. What is the difference between a “line feed” and a “carriage return”?
  55. How to convert an int to string in C?
  56. Check string “None” or “not” in Python 2.7
  57. What’s the best way to convert a number to a string in JavaScript?
  58. How to replace all double quotes to single quotes using jquery?
  59. How to split a string in Java
  60. How to convert a std::string to const char* or char*
  61. Regex how to match an optional character
  62. Left Hand Side of an Assignment must be a Variable CharAt
  63. How to get the filename without the extension from a path in Python?
  64. How do I apply the for-each loop to every character in a String?
  65. Parsing a comma-delimited std::string
  66. Java – removing first character of a string
  67. Explain the use of a bit vector for determining if all characters are unique
  68. How can I remove punctuation from input text in Java?
  69. Sort a single String in Java
  70. Convert a String In C++ To Upper Case
  71. What is Java String interning?
  72. Right way to split an std::string into a vector
  73. How to remove text from a string?
  74. PHP: variables in strings without concatenation
  75. Select method of Range class failed via VBA
  76. How to sort an array of objects in Java?
  77. C++ Simple hangman game
  78. Remove First and Last Character C++
  79. How to compress a String in Java?
  80. C++ Convert string (or char*) to wstring (or wchar_t*)
  81. Java end of file
  82. Unclosed Character Literal error
  83. Add String Array to ArrayList
  84. StringIndexOutOfBoundsException String index out of range: 0
  85. Trying to use int in getline
  86. Difference between String replace() and replaceAll()
  87. How does str(list) work?
  88. Does C have a string type?
  89. Check if URL has certain string with PHP
  90. How to do std::string indexof in C++ that returns index of matching string?
  91. variable or field declared void
  92. Insert a string at a specific index
  93. Extract filename and extension in Bash
  94. Meaning of #{ } in Ruby?
  95. realloc(): invalid next size when reallocating to make space for strcat on char *
  96. Why cannot cast Integer to String in java?
  97. Why are there two different getline() functions (if indeed there are)?
  98. Convert an array to string
  99. Why does my program give “NULL used in arithmetic”
  100. In Java, how do I parse XML as a String instead of a file?

Leave a Comment