Counting specific types of characters in a cell

dcxkraze

New Member
Joined
Oct 20, 2005
Messages
12
Question:

Cell 1A contains "XXX-XXX, XXX-XXX, XXX-XXX"

Cell 1B needs to count and return the number of dashes ("-") in cell 1A, so in this case "3".

Any tips would be greatly appreciated.

Thanks,

Brandon
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,119,264
Messages
5,577,081
Members
412,763
Latest member
sienweiw
Top