title: Take all elements of .Split (' ') and take last OR exclude last item
body: <p>I have an inconsistend address field which I am reading from excel. I need to split this field and enter those 2 values into two list properties.</p>
  
  <p>the content could be something like this </p>
  
  <blockquote>
    <p>At the gates 42</p>
  </blockquote>
  
  <p>I need to split the number from the rest and add "At the gates" to the property "Street" and "42" to the property "number"</p>
  
  <p>I have solved the problem with taking the number with this:</p>
  
  <pre><code>Number = Convert.ToString(ws.Cells[j + 3, i + 2].Value).Split(' ').LastOrDefault()
  </code></pre>
  
  <p>How can I split this string with Linq and just exclude the last number to get the street?</p>
  
  <p>Kind regards</p>