The word "from" or ANY last word in the sentence?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JAF-In" wrote in message
...
how can i retrieve text from one column to another except one last word
for eg:The text "how can i retrieve text from" is in column A1 and i have
to
retrieve "how can i retrieve text" to B1