Help clean file of unnecessary character in columns

RE: Post #22.
I don't believe that you should be getting that pop up when copying end times from the tournaments sheet and pasting special values to the my staking sheet.
Try the following:
1. Select cell G12 on the tournaments sheet
2. Press the Ctrl, Shift and down arrow keys
3. Press the Ctrl and c keys
4. Select cell F51 on the my staking sheet
5. Press the Ctrl, Alt and v keys
6. Press the Alt and v keys
7. Select OK at the bottom of the dialog box
Note that you may need to change the formatting of the newly pasted cells as you did in post #16.

thank you, I am having trouble with this.
okay i did the above steps i copy as the instruction
since all the formulas paste below i when and copy everything to the bottom where i did the steps
then delete all the above rows leaving the bottoms rows and gives the same result. #Value!
change format to [$-en-US]mmmm d, hh:mm
i get more issues doing this steps as i need to delete all my deposits rakeback due to formulas been paste below row 51 then copy all text to the bottom will look into this
in a bit see if i can fixed it in a different way