title: Excel formula: Left & function Right
body: <p>Good day all, 
  I'm trying to chop off 9 characters starting from the right in a cell, 
  when I use the "RIGHT FUNCTION" excel returns the 9 characters chopped off from the right. But I want excel to chop off 9 characters from the right and return the remaining characters to the left. However, I can't achieve this with the "LEFT FUNCTION" because the number of characters to the left varies. Please i need the exact function to chop off 9 characters from the right and the remaining characters to the left will be returned to Cell E5 
  Example below:
  Cell E3 = "HP Deskjet 1510 series (Copy 1) on Ne14:"
  I need to chop off " on Ne14:" and return "HP Deskjet 1510 
  series (Copy 1)" to Cell E5. 
  Thanks In Advance.</p>