Re: $$Excel-Macros$$ No. of Occurrence of char in string

Thanks Rohan, :) Noorain has given 1 very easy code Dim str str = Split(rng, word) Count_character = UBound(str) > > From: Rohan >To: MS EXCEL AND VBA MACROS >Sent: Wednesday, 14 December 2011 1:06 AM >Subject: Re: $$Excel-Macros$$ No. of Occ

Re: $$Excel-Macros$$ No. of Occurrence of char in string

; From: NOORAIN ANSARI >To: excel-macros@googlegroups.com >Sent: Monday, 12 December 2011 8:00 PM >Subject: Re: $$Excel-Macros$$ No. of Occurrence of char in string > > >Dear Hanumant, >  >Please try it.. >  >Function Count_character(rng As Range) >Dim str As Variant

Re: $$Excel-Macros$$ No. of Occurrence of char in string

This will count the input that the user makes in the input box prompt and will display the count in a Message Box. Sub Test() Dim StartVal As Integer Dim Count As Integer Dim InputCount As Variant InputCount = InputBox("Please enter the input u want to count") For StartVal

Re: $$Excel-Macros$$ No. of Occurrence of char in string

>> 2) Don't post a question in the thread of another member. Don Guillett SalesAid Software dguille...@gmail.com From: yogiyogi123 Sent: Tuesday, December 13, 2011 1:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ No. of Occurrence of char in string hai

Re: $$Excel-Macros$$ No. of Occurrence of char in string

hai all :i form hyderabad i want learn VBA Course can you suggest me any books or institutions in hyderabad. On Mon, Dec 12, 2011 at 8:18 PM, rajan verma wrote: > VBA Function Provided By Noorian is nice trick > > Try This with Shift +Ctrl+Enter > =SUM(IF(--CODE(MID(B3,ROW(INDIRECT("A1:A"&LEN(

Re: $$Excel-Macros$$ No. of Occurrence of char in string

VBA Function Provided By Noorian is nice trick Try This with Shift +Ctrl+Enter =SUM(IF(--CODE(MID(B3,ROW(INDIRECT("A1:A"&LEN(B3))),1))=CODE(C3),1,0)) On Mon, Dec 12, 2011 at 8:00 PM, NOORAIN ANSARI wrote: > Dear Hanumant, > > Please try it.. > > *Function Count_character(rng As Range) > Dim str

Re: $$Excel-Macros$$ No. of Occurrence of char in string

Dear Hanumant, Please try it.. *Function Count_character(rng As Range) Dim str As Variant str = Split(rng, "e") Count_character = UBound(str) End Function * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.b

Re: $$Excel-Macros$$ No. of Occurrence of char in string

Thanks Muni. this is wati got from online search. > > From: Muni >To: excel-macros@googlegroups.com >Sent: Saturday, 10 December 2011 1:58 AM >Subject: Re: $$Excel-Macros$$ No. of Occurrence of char in string > > >you can try this >

Re: $$Excel-Macros$$ No. of Occurrence of char in string

you can try this if "excel" is in A2 cell then LEN(A2)-LEN(SUBSTITUTE(A2,"e","")) Regards Muni On Fri, Dec 9, 2011 at 3:10 PM, hanumant shinde wrote: > Hi All, > > it was an interview que. > > how will you find number of occurrence of any character from string. > he said you can do it using 1 e

Re: $$Excel-Macros$$ No. of Occurrence of char in string

got the ans with lots of other things just check this out. http://support.microsoft.com/kb/187667 > > From: hanumant shinde >To: Excel Group >Sent: Saturday, 10 December 2011 1:40 AM >Subject: $$Excel-Macros$$ No. of Occurrence of char in stri

$$Excel-Macros$$ No. of Occurrence of char in string

Hi All, it was an interview que. how will you find number of occurrence of any character from string. he said you can do it using 1 excel formula or you can use VBA. can somebody tell me the answer in both Excel as well as in VBA. eg. if string is "excel" then there are 2 "e"s in this string.