=SUBSTITUTE(A1," word","")

extracts it from anywhere. Does it suit your needs?

Regards,
Stefi


€žanthony€� ezt Ã*rta:

how do i use the mid function to extract the "word" between the second and
third spaces or between the fourth and fifth spaces or even between the
second and fourth spaces?

thanks in advance