RE: $$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Needed)

2012-07-28 Thread Rajan_Verma
End Function Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pesh Sent: 29 July 2012 2:08 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Nee

$$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Needed)

2012-07-28 Thread pesh
Dear Excel Experts, I could really use your help. I am trying to take a string and with VBA code tally the number of instances of a word and then output into an excel sheet. For example, String >> "People: Tom Hanks(Actor), Michael Jordan(Businessman, Athlete), Fred Astaire (Dancer), Donald