View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KrispyData KrispyData is offline
external usenet poster
 
Posts: 24
Default Retrieve first 3 words in a cell

I have an address field and I would like to create a formula to retrieve the
first 3 words in the address. How can I do this?

example:

1245 main street suite 10

i would like the result to be:

1245 main street

thanks so much for any help!