title: Trimming cell with multiple carriage returns
body: <p>I have a spreasheet from an csv formatted exported report which contains an address field with multiple lines.</p>
  
  <p>Here is an example of the cell contents (I have used an image to show the question mark at the end of each line):</p>
  
  <p><img src="https://i.stack.imgur.com/wgMUB.jpg" alt="enter image description here"></p>
  
  <p>I need to extract the suburb (in this case Brooklyn) from the address however the challeneg I have is there are some cases where there is an extra line in the address, for example:</p>
  
  <p><img src="https://i.stack.imgur.com/QdvgQ.jpg" alt="enter image description here"></p>
  
  <p>In all cases the Suburb will always be the second to last line so my though was to somehow work backwards but I have no idea how to do it as a formula.</p>
  
  <p>ANy help would be very much appreciated. </p>