Thread: How can I get Excel (2003) to return just the first 4 words (of another cell)?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How can I get Excel (2003) to return just the first 4 words (of an
try this with your string in A1

=LEFT(A1,FIND(" ",A1,FIND(" ",A1,FIND(" ",A1,FIND(" ",A1,FIND("
",A1,1)+1)+1)+1)))

Mike

"ship" wrote:

Hi

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


Ship
Shiperton Henethe


Reply With QuoteReply With Quote