Thread: Find number of spaces in a string (instr)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Find number of spaces in a string (instr)
One way:

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

In article ,
DejaVu wrote:

Is there any way to find out how many spaces (or any other character)
are in a string?
I need to find out how many '+' are in a string.

TIA

DejaVu
Reply With QuoteReply With Quote