=MID(A1,7,50)
dragged down. Then you can copy and paste special to remove the formula. Does that work for you?