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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
http://www.bredlum.com/ee_temp/xlCharCount.xls
has the function in a module and tested in a sheet
ASKER
i put the module in the wrong place...my bad. thanks, excellent answer
cool thanks for the grade
ASKER