To remove use :VALUE(12345).TRIM(4); finally 4 have been remove from 12345 what is left is 1235 To replace use :VALUE(12845).REPLACE(["8","3"]); finally 8 has been replace with 3 therefore output is now 12345

comment