How many commas are there in a cell??
[Originally posted by Kousik]
I am writing an Excel VBA macro. I would like to know how to know the number of commas are there in a cell. Each cell has text like this.
Name, Address, City,State,Zip, Tel.
but at times name/address fileds has data like˙ (name, Inc.,)/(1234, Center ct,).
So if i know the total commas in the cell, then i can figure out how many commas are in name/address fields.
Re:How many commas are there in a cell??
[Originally posted by PraveenMenon]
MsgBox UBound(Split(Text1.Text, ","))
can retreive the number of commas in text1.text..
All the best,
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL