Assuming you have no carets (^) in your cell, and assuming the cell with the
string you want to act on is A1, try

=LEFT(A1,FIND("^",SUBSTITUTE(A1," ","^",4))-1)


"ship" wrote:

Hi

How can I get Excel (2003) to return just the first 4 words of another
cell?
With thanks


Ship
Shiperton Henethe