The easiest way is to add a column with a formula that throws away the 5 leftmost characters of the original cell. Then use Copy>Paste Special to replace the original column.

I'll leave it to you to assemble the all-in-one formula, but these are the elements:
- length of contents: =len(a1)
- subtract 5
- use right-function to extract the needed characters

Kees