For finding 1st position number of the space
=FIND(" ",A1)

For finding 2nd position number of the space
=FIND(" ",A1,FIND(" ",A1)+1)

For finding 3rd position number of the space
=FIND(" ",A1,FIND(" ",A1,FIND(" ",A1)+1)+1)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Steve Stad" wrote:

Can you tell me how to find the position number of the third space in a
string of varying length and text.
e.g.,
123 456 789 111 222
need to find position number of space between 789 and 111
or in:
abcd efghi jklmnopqr stuvxy
need position number of space between "r" and 's'.

I am familiar with =find(" ",a1) to find a space but need help with logic
for third or second space.