In an adjacent column, =mid(a1, 2, 32767)

Then copy, paste as values, and delete the original column.