Hello everyone!

Your last msgs really helped me out. But now here is a new trouble fo
all the VBA addicts outhere ! not a big challenge, I guess, but stil
for me, it is. I've tried to search through the forum, but I didn'
find anything regarding my needs:

here is what's inside cell B14:
" Franchisor is a privately-held company with 650 employee(s); 2
employee(s) in franchise department"

Thanks to your previous help, I've been able to extract by myself th
numbers 650 and 20, and put'em respectively in E14 and D14 by using i
my macro:

Range("e14").Value = Val(Right(Range("b14").Value, 38))
Range("d14").Value = Val(Right(Range("b14").Value, 55))

However, I would like now to have in C14 the "word" which is in 4t
position of the sentence, here it is "privately-held".
I've tried with the same kind of formula (Val(Right ... etc) but I jus
got 0 and not the word itself _<

How can I get out the 4th word of this cell? (in some cases, it won'
be privately-held, but independant etc etc: I just know that th
sentence will always be like "Franchisor is a ......... company" ?

Thanks for your future help!
VBA is Alive :-

--
crazy_vb
-----------------------------------------------------------------------
crazy_vba's Profile: http://www.excelforum.com/member.php...fo&userid=3367
View this thread: http://www.excelforum.com/showthread.php?threadid=53522