Dropping the first character

To drop the first character of a text cell, keep every character after it.

RIGHT can take characters from the end of the cell. LEN counts the characters, so LEN minus one is how many characters to keep.

Example

A: Code
X-1042

Formula: =RIGHT(A2,LEN(A2)-1)

Result: -1042

X-1042 has six characters. LEN minus one is five, so RIGHT returns the last five characters and the leading X is gone. The hyphen stays because it is not the first character.