mid/find functions

D

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
 
D

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!
 
J

JE McGimpsey

one way:

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


where 32000 is just a large number.
 
Top