Help clean file of unnecessary character in columns

Hi, would like to get help for columns B:J to be clean in columns L:T
for example I Did column B shows Date twice Jun 07, 11:45Jun 0711:45 and on L now shows only Jun 07, 11:45 manually corrected.

biggest issue here is I want column C tournament and D entry to just return 1 Row per Entry as you can see row 3 & 4 i entry 2 times showing
Jun 07, 11:00Jun 0711:00 356-L: $2.50 Friday Night Mini Fight [Bounty 6-Max]Buy-in $2.50 Prize $25,371.52 10,936
Jun 07, 11:00Jun 0711:00 356-L: $2.50 Friday Night Mini Fight [Bounty 6-Max]Buy-in $2.50 Prize $25,371.52 10,936 #2
I manually corrected and input in row 2

Note: would be great if row 2 M column tournaments has buy-in players and Total prize if it can fill columns O:Q
For Prize column T i am using formula
=IF(ISNUMBER(SEARCH("$",J2)),MID(J2,2,SEARCH(" ",J2)-SEARCH("$",J2))+0,"")