Counting chars in a string

[bcmiller]

Hi,

I am writing some code to insert new records into an excel databas
where a key value has muliple values in the one record.

The separator is a comma.

Is there a way to count the number of comma's in a given string withou
having to write a new function???

Cheers,

b

 

[yogendra joshi]

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

 

[bcmiller]

Thanks Yogendra,

I had written a for loop to do the job, but that was slowing my macr
down, your tip has cut the size of my code and its execution time.

Cheers,

B