Hi,

For the first word, try this

=left(E5,search(" ",E5)-1). This assumes that there will be a space after
the first word

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"confused!!" wrote in message
...
that worked wonderfully.

One more time how do I extract the first and second word only?

"Ron Rosenfeld" wrote:

On Wed, 9 Sep 2009 05:42:22 -0700, confused!!
wrote:

currently in cell E5 = MACPAC VER 10 PGMR *Keep Profile* Clarksville

how do i extract the last word in this cell?

Try this:

=TRIM(RIGHT(SUBSTITUTE(E5," ",REPT(" ",99)),99))

--ron