# Counting characters within a column....

#### patt_the_ski

##### New Member
I need a formula that will go through a series of invoices and seperate them by the text code within the invoice series. I have an example of column A1 "BC, BS, BA" are all contained within the numbers how go I keep a count of each?

200BC000000101
200BS000005201
200BA000000101
200BC000010201
200BC000010301
200BS000020601
200BA000018101
200BA000019201
200BS000093801
200BC000096301

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
You could start with Data - Text to columns - and fixed lenght.
This way you can separate each series.

Pekka

for example:

=COUNTIF(Range,"*BS*")

maybe?

Replies
13
Views
241
Replies
2
Views
258
Replies
18
Views
501
Replies
5
Views
173
Replies
12
Views
197

1,207,424
Messages
6,078,448
Members
446,339
Latest member
keogata

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