How to convert a character into an integer

[aquar]

I'm rather new to VBA and excel. I have a similar situation to this post. I would like to convert a character, in this instance a "check mark," into an integer value of either one or negative one. I have found the SUBSTITUTE function, but I am not sure how to use it. Could someone show me a step-by-step process to achieve this? My goal is to COUNT the number of check marks in a column, as either a positive or negative number. I know I can use NUMBERS within a column and then use the COUNT function to achieve the results, but I would like to use a check mark instead. Thank you.

[DonkeyOte]

Can you clarify how you're adding the check mark ? (ie symbol or via font)

Pending answer to the above you may find a standard COUNTIF will suffice.

If possible post a sample file that illustrates your checkmark entry.

[snb]

If the checkmark in B1; then put into C1

=code(lower(B1))-96