Community discussion forum

Re: How can i search a string include ' example 'John

• • Reply

  1 year ago

  by sync_or_swim

  Rob Bickel

  S. Wales, United Kingdom

  Joined 4 years ago

  Hi, What exactly areyou trying to do? Could you provide a little more information?
  
  If you have a string, yuou can use the InStr function to discover whether it contains a certain substring/character.  eg.
  
  Dim myString As String
  myString = "'John"
  If InStr(1, "myString", "'") > 0 Then
       'The string is present
  End

  Report abuse