Formula to count number of characters before the 1st space in a text string

[freeb1893]

Anyone know a formula to count number of characters before the 1st space in a text string?

For example here:
###$%DF@12 SSD FSS F123

My formula would produce a result of "10"

Thanks in advance

 

[rpaulson]

=find(" ",a1)-1

 

[freeb1893]

Thanks!

=find(" ",a1)-1

 

[chris0b]

=find(" ",a1)-1

thank you!