Yeah, in case there's a string that's blank or too short for the Left and Right to work properly.
As Joe said, you can probably use the Replace function better if it supports the 'normal':
Replace(string, find, replace[, start[, count[, compare]]])
.. VBA format in field calculator.