ExcelBanter - Counting a Specific Character

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting a Specific Character (https://www.excelbanter.com/excel-discussion-misc-queries/228991-counting-specific-character.html)

FARAZ QURESHI

Counting a Specific Character

Any suggestion/formula to count the number of times the character "+" is
present in $A$1?

Thanx

Gary''s Student

Counting a Specific Character

=LEN(A1)-LEN(SUBSTITUTE(A1,"+",""))

--
Gary''s Student - gsnu200849

"FARAZ QURESHI" wrote:

Any suggestion/formula to count the number of times the character "+" is
present in $A$1?

Thanx

FARAZ QURESHI

Counting a Specific Character

Wow man! XClent!

As I had stated earlier a Master like you can't be a Student.

"Gary''s Student" wrote:

=LEN(A1)-LEN(SUBSTITUTE(A1,"+",""))

--
Gary''s Student - gsnu200849

"FARAZ QURESHI" wrote:

Any suggestion/formula to count the number of times the character "+" is
present in $A$1?

Thanx

All times are GMT +1. The time now is 03:20 PM.