Count Spaces In A String

Josh in Tampa · Oct 23, 2003

anyone know how i can count the number of spaces in a
string?

thanks.

Jim Rech · Oct 23, 2003

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

Jim Rech · Oct 23, 2003

Or in VB:

Len(Strg) - Len(Replace(Strg, " ", ""))

How do you count the number of * in a string?	5	Jan 14, 2010
Count the number of characters created by string text	6	Jan 19, 2007
Userform textbox string to header causes unwanted double spacing	4	Nov 17, 2014
Count Space, comma and fullstop in a string	6	Nov 7, 2006
counting spaces	5	Nov 2, 2008
How best to parse string lists of numbers	7	Apr 12, 2009
counting spaces in a string	4	Dec 16, 2003
How to Count String occurences	4	Mar 22, 2005

Ask a Question