# How to count letters

#### zkiraly

##### New Member
Hi,

If I have letters written in some of the cells of a column (instead of numbers), what formula can I use to tell excel to count up the number cells that have letters in the column?

Thank You

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
If I'm understanding your question correctly, you have a column with numbers in some cells and letters in others and you want to know how many have numbers in them. Is this correct?

If so, perhaps:

Formula in F1:
=COUNT(D1:D6)
Book4.xls
DEFG
113
2A
32
4B
5B
63
Sheet1

Provide a tiny sample along with the desired result.

Ok,

let's say the following information is in column G:

"DW" is in cell G10
"D" is in cell G14
"DW" is in cell G20

So 3 cells in column G have writing in them. How can I get excel to return the number 3 in cell H1, for example. No cells in column G will contain numbers, I am only talking about counting up the cells in column G that contain writing.

OK,

It sounds like it's either text or nothing, so how about something like this:
=COUNTA(G1:G100)

Replies
7
Views
111
Replies
3
Views
123
Replies
2
Views
96
Replies
1
Views
97
Replies
20
Views
469

1,203,606
Messages
6,056,279
Members
444,854
Latest member
goethe168

### 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