title: Remove or add text after a specific character in Excel
body: <p>I have lot of data in my excel sheet , i want to remove all text after Last  (-) character . 
  Here is sample data like in my sheet</p>
  
  <pre><code>"This-is-car-44"
  "This-is-my-school-ok"
  </code></pre>
  
  <p>I want look like this </p>
  
  <pre><code> "This-is-car"
   "This-is-my-school"
  </code></pre>
  
  <p>i want to remove all text after lats - , so is their any formula to do this. 
  and one thing more if possible can i do like this in excel </p>
  
  <pre><code> "This-is-car-44"
      "This-is-my-school-ok"
  </code></pre>
  
  <p>to look like this</p>
  
  <pre><code>  "This-is-car/"
      "This-is-my-school/"
  </code></pre>
  
  <p>i mean after last - remove all text and add this / in end .
  thanks. </p>