Replace First Character

[bsolove]

I have a bunch of a values, some of which have a decimal (.) as the first character.  I want to remove the first character, if it is a decimal.  I tried playing around with regex replace, but no luck.

[BrianR · Accepted solution]

Here's a solution using the Left and Right functions to evaluate and remove the decimal - only if it exists.