Checking blank spaces

[rajabadsha]

Can anyone tell me how to check blank spaces. For example I am trying to check whether or not there is a blank space in an Excel cell. The blank space could be in the following form
no space = ""
one space = " "
two space = " "
and so on. ... There could be more combination.

[danasegarane]

Try this one

Private Function isSpaceExist(ByVal stext As String) As Integer
        Dim npos As Integer = 0
        Dim ncount() As String
        npos = stext.IndexOf(" ") 'if a space is found
        If npos Then
            ncount = stext.Split(" ") 'split with respect to space
            'Print the number of spaces
            Console.WriteLine("No of space found: " & ncount.Length.ToString)
        End If
        Return ncount.Length
    End Function