title: replace everything after a character in Google spreadsheet
body: <p>I did some searching and in openoffice and excel it looks like you can simply add an * at the beginning or end of a character to delete everything before and after it, but in Google spreadsheet this isn't working. Does it support this feature? So if I have:</p>
  
  <pre>keyword USD  0078945jg .12 N N 5748 8</pre>
  
  <p>And I want to remove USD and everything after it what do I use? I have tried:</p>
  
  <pre>USD* and (USD*) with regular expressions checked</pre>
  
  <p>But it doesn't work. Any ideas?</p>