You could simple enter a formula like this

=LEFT(A2,6)&MID(A2,8,LEN(A2))

into another column, copy down, then copy and paste values over the
original.
Either manually or with a macro would be simple...

Another possibility...

=REPLACE(A2,7,1,"")

Rick