Count spaces before specific character in cell

[spill-the-beans]

Hi

Is it possible to create a formula that will count the number of spaces in a cell that occur before a specific character?

So if the contents of A1 was: "The quick fox (jumped/leaped) over"

Then B1 would read 3, because there is are 3 spaces before the open bracket, and any spaces after that open bracket are not included in the count.

Any help would be really great!

 

[Jonmo1]

Try

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

 

[njimack]

=find("(",a1)-find("(",substitute(a1," ",""))

 

[spill-the-beans]

Fabulous, thank you so much, it works perfectly!

 

[Jonmo1]

=find("(",a1)-find("(",substitute(a1," ",""))

Nice