How many "," in my string... Is there a function for that?

[mtheriault2000]

Hello

If I want to get the numbers of comma (,) in my string. Is there a function to do that?

Martin

 

[jeffreybrown]

How about...

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

 

[Gary McMaster]

In VBA you could use the "Split" function.

Gary

Public Sub Test()

Dim iCount As Integer
Dim sText As String

sText = "a,b,c,d,e,ffff,gg,hhh,i,j,"

iCount = UBound(Split(sText, ","))

MsgBox iCount

End Sub

 

[mtheriault2000]

In VBA you could use the "Split" function.

Gary

Public Sub Test()

Dim iCount As Integer
Dim sText As String

sText = "a,b,c,d,e,ffff,gg,hhh,i,j,"

iCount = UBound(Split(sText, ","))

MsgBox iCount

End Sub

Whow!! I'm impress
I who you a beer guy's