Help clean file of unnecessary character in columns

thank you,
I get this pop up when trying to paste formula in post #28 into file in #27
not sure whats going on but in file in post # 27 spin & gold show #value! too
I Requested a transactions history from GG Poker to help have everything to the perfection as i would like to get all bankroll stats figure out hope we can do some progress
hope the file helps. this is the file.
mate, after looking at the file for some reason Battle Royale is in type as tournaments mixed tournaments with battle royale games. only spin & gold seem to be in is own type along with cash. Side bets is part of the spin & gold insurance SGI sit N G I insurance it works as if you hit some type of multiplier they refund back the buyi-in or you pay dobule.

Do you think putting in the Battler Royale within tournaments be a good idea? or keep separate? I am going to eliminate lots of the things that casue trouble like Insurance the side bet. for cash i think is also combine the rush cash and the Hold'em since they are cash games.
if we can combine i think we can eliminate 2 sheets the hold'em & battler royale. please let me know your thoughts on this

can you please make some kind of pivot table for file Players balance History so i can try to analize whats going on with loss profit and games
okay as i am looking into this file I see Tournaments, Battle royale, and my staking games all mixed. though i mention this. i see daily hypersonic $50 -9.53 and 16.08 under tounaments