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

--
Message posted from http://www.ExcelForum.com

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

bcmiller < wrote:
Hi,

I am writing some code to insert new records into an excel database
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 without
having to write a new function???

Cheers,

bc


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com