How can i count "spaces" in any sentence or a string if suppose " It is a Testing question" Here we have 4 gaps(spaces) Is there any function to find out spaces between words
arrResult= split("It is a Testing question", " ") msgbox "No. of Spaces " & ubound(arrResult)