find multiple space locations

[lezawang]

Hello all
I used find() to find the location of the first space in the following text

123 main street

and find() returned 4, so far so good. now i am wondering if i want to find the location of the second space in that text, what should i do?

Thank you so much.

 

[mrshl9898]

=find(" ",a1,find(" ",a1)+1)