Count Characters in Single Cell

This formula is case sensitive.

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

This formula is not case sensitive. (I've seen this formula on a few sites now but thanks Jeroven!)

=LEN(A1) - LEN(SUBSTITUTE(LOWER(A1), LOWER("a"), ""))


© Copyright 2004 - 2007, andrewsexceltips.com. All Rights Reserved.