# Searching for Special Characters

#### Dan Wilson

##### Active Member
Good day. I am using Excel in Office 365 (updated) running on Windows 10 Home. I have a worksheet that contains song titles and artist names. Column B holds the artist names. There is an Artist whose name begins with a question mark (? And The Mysterians). In another worksheet I have created Column A to house the first letter of each artist title found in the song worksheet (DB). IE: =LEFT(DB!\$B29,1) This formula is used to extract the first letter of each artist from 4500 songs. Then I created Column B to count the number of cells that contain the letters A thru Z, numbers 1 thru 9, and special characters (" and ?). IE: =COUNTIF(\$A:\$A,"A") The search for letters, numbers and the " all work. The search for ? (=COUNTIF(\$A:\$A,"?") gives me a total of 4500 meaning that it counted everything. Is there a way to make the search work? I appreciate any help.
Thank you,
Dan Wilson...

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### Fluff

##### MrExcel MVP, Moderator
Try
Excel Formula:
``=COUNTIF(\$A:\$A,"~?")``

#### Dan Wilson

##### Active Member
Try
Excel Formula:
``=COUNTIF(\$A:\$A,"~?")``
Good day Fluff. You did it again! Thank you for responding. It took me a while to find that key (~), but it worked. I suspect that it will work for other special keys aa well (+,-,/,*). This one is now closed.
Thank you,
Dan Wilson...

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
17
Views
440
Replies
0
Views
84
Replies
3
Views
130
Replies
10
Views
863
Replies
27
Views
632

1,137,125
Messages
5,679,773
Members
419,855
Latest member
Eddier32

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back