An alternative formula in the helper column is:

=RIGHT(A1,LEN(A1)-9)

As Ron suggests, you can then:

Copy/Drag down as far as required.
Then,
Select the cells in the helper column
Edit/Copy
Select A1
Edit/Paste Special Values
Then Delete Helper Column.

Hope this helps.

Pete