Text Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Text Functions
  4. Use the REPLACE function to replace one character beginning at position 5 with nothing
Input the formula: =REPLACE("####-544",5,1,"")