Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Use the REPLACE function to replace one character beginning at position 5 with nothing

Input the formula: =REPLACE("####-544",5,1,"")