Use the REPLACE function to replace one character beginning at position 5 with nothing : REPLACE « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. REPLACE
Input the formula: =REPLACE("####-544",5,1,"")
Input the formula: =REPLACE
22.17.REPLACE
22.17.1.REPLACEB(old_text,start_num,num_bytes,new_text) replaces characters within textREPLACEB(old_text,start_num,num_bytes,new_text) replaces characters within text
22.17.2.=REPLACE(A3,3,2,"10")=REPLACE(A3,3,2,
22.17.3.Use the REPLACE function to replace one character beginning at position 5 with nothingUse the REPLACE function to replace one character beginning at position 5 with nothing