S
Steve Stad
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.
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.