mid/find functions

[dave]

is there a way to return text from a text string (I'm
using the mid and find functions) where you'd like your
starting point to be the 4th space in the text string?

I can find a space, but it always looks to the first one.

tia,
Dave

 

[Domenic]

The following should give the position of the fourth space...

=FIND("@",SUBSTITUTE(A1," ","@",4))

Using it with the MID function you could have something like this...

=MID(A1,FIND("@",SUBSTITUTE(A1," ","@",4))+1,255)

Hope this helps!

 

[JE McGimpsey]

one way:

=MID(A1,FIND("$",SUBSTITUTE(A1," ","$",4))+1,32000)


where 32000 is just a large number.

 

[dave]

thanks for your help.