title: What is the formula to keep first two words in a cell over excel?
body: <p>My D1 cell contains name like <code>John Smith Rangpur Bangladesh 5400...</code> i want to keep first two words like <code>John Smith</code> and delete rest from cell. What will be formula to do that?</p>
  
  <p>I've used this formula on C1 <code>=LEFT(D1,FIND(" ",D1)-1)</code> but it returnes 1st word (John) only. How to get 1st and 2nd word like <code>John Smith</code> ?
  My word are separated with <code>space.</code></p>
  
  <p>Thanks in advance.</p>