Link to home
Start Free TrialLog in
Avatar of chad201008
chad201008

asked on

count the number of special characters in a excel worksheet cell

i want to count the number of special characters in a excel sheet cell.  if a cell has the text "jimjim" in it and i want to count the number of "j"'s in the string, how would i do it.
ASKER CERTIFIED SOLUTION
Avatar of Brian Mulder
Brian Mulder
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chad201008
chad201008

ASKER

when i enter the code i get a error in the cell-#name? and i don't understand what i'm missing.  any ideas?
you can pick up a sample here

http://www.bredlum.com/ee_temp/xlCharCount.xls

has the function in a module and tested in a sheet
i put the module in the wrong place...my bad.  thanks, excellent answer
cool thanks for the grade