Spreadsheet: 322268d1401691484-same-name-in-cells-is-formatted-differently-how-can-i-replace-with-a-consistent-format-6-2-14-deep-testing
Sheet: Trade w Dorks for #1s

SHINE ON YOU CRAZY DIAMOND - FRANK HORTON |  | ROS | Chad | Age | [NAME] |  | NEW YORK DORKS - RICHARD VALLEJO |  | ROS | Chad | Age | [NAME]
PLAYER | YTD PTS |  |  |  |  |  | PLAYER | YTD PTS
Bryant, Dez DAL WR (P) | 190.6 | 5 | 4 | 25 | 1 |  | Flacco, [NAME] | 199.2 | 18 | 28 | 28 | 29
Luck, Andrew IND QB | 240.2 | 13 |  | 24 | 1 |  | [NAME], [NAME] MIN QB | 46.1 | 41 | 36 | 25 | 35
Smith, Torrey BAL WR | 151.9 | 15 | 14 | 24 | 10 |  | Locker, Jake TEN QB (I) | 120.5 |  | 18 | 25 | 25
Miller, [NAME] | 92.5 | 30 | 15 | 22 | 11 | 26 | [NAME], [NAME] (R) | 43.6 | 27
Manuel, [NAME] (R) | 111.2 | 23 |  | 23 | 13
[NAME], Christine SEA RB (R) | 7.9 |  | 12 | 23 | 17 |  | Dunbar, Lance DAL RB | 15.5 | 69 |  | 23 | 75
Pierce, [NAME] | 56.9 | 61 | 24 | 22 | 18 |  | Greene, Shonn TEN RB | 24.3 | 59 | 69 | 28 | 74
Franklin, [NAME] (R) (I) | 21.7 |  | 35 | 24 | 38 |  | [NAME], [NAME] WAS RB | 87.8 | 44 | 38 | 24 | 58
Turbin, [NAME] | 30 | 70 | 40 | 23 | 62 |  | Ingram, [NAME] | 36.1 | 54 | 47 | 23 | 41
[NAME], [NAME] | - |  | 66 | 23 | 64 |  | McCoy, LeSean PHI RB | 208.8 | 4 | 2 | 25 | 1
Rogers, Da'Rick IND WR (R) | - |  |  | 22 | 75 |  | Ogbonnaya, [NAME] CLE RB | 88.8 | 48 |  | 27 | 106
Brazill, LaVon IND WR | 10.5 |  |  | 24 | 84 |  | [NAME], Theo DET RB (R) | 4
[NAME], [NAME] | 10.8 |  | 51 | 25 | 86 |  | [NAME], [NAME] (Q) | 97.1 | 33 | 19 | 25 | 19
Mellette, [NAME] (R) (I) | - |  |  | 23 | 91 |  | [NAME], Stepfan ARI RB (R) | 8.6 |  | 63 | 22 | 69
Hillis, Peyton NYG RB | 31.7 |  |  | 27 | 95
Blount, [NAME] | 45.4 | 66 |  | 26 | 97 |  | Blackmon, [NAME] (S) | 76.4 |  | 23 | 23 | 18
[NAME], [NAME] (R) | 0 |  |  | 22 | 102 |  | [NAME], [NAME] (Q) | 51.9 | 56
Harper, Chris GBP TE (R) (O) | 0 |  |  | 24 | 102 |  | [NAME], [NAME] (Q) | 145.4 | 25 | 9 | 23 | 15
Green, Ladarius SDC TE | 50.9 | 22 | 13 |  |  |  | [NAME], [NAME] CLE WR | 186 | 6 | 6 | 22 | 6
McDonald, Vance SFO TE (R) | 19.9 |  | 21 |  |  |  | Hankerson, Leonard WAS WR (I) | 85.5 |  | 78 | 25 | 77
Allen, Dwayne IND TE (I) | 9 |  | 22 |  |  |  | [NAME], [NAME] TEN WR (R) | 54.1 | 66 | 29 | 22 | 37
Butler, Brice OAK WR (R) (O) | 19.3 |  | 55 |  |  |  | Jenkins, A.J. KCC WR | 4.8 |  |  | 23 | 81
[NAME], [NAME] (R) (O) | - | 19 | 74 |  |  |  | Jones, [NAME] | 122.8 | 20 | 52 | 23 | 51
[NAME], [NAME] | 5.8 |  | 83 |  |  |  | Nicks, Hakeem NYG WR (Q) | 104 | 42 | 39 | 25 | 19
Hemingway, Junior KCC WR | 10.7 |  | 89 |  |  |  | Pettis, [NAME] | 81.7 |  | 76 | 25 | 163
 |  |  |  |  |  |  | Quick, Brian STL WR | 43.5 |  | 64 | 24 | 69
 |  |  |  |  |  |  | Eifert, Tyler CIN TE (R) | 74.7 | 30 | 4
 |  |  |  |  |  |  | [NAME], Jermaine CIN TE | 79.8 | 25 | 19
Kaufman, [NAME] (R) | - |  |  |  |  |  | Rivera, Mychal OAK TE (R) (P) | 62 | 28 | 40
Raiders, Oakland OAK Def | 137 | 25 |  |  |  |  | Bengals, Cincinnati [NAME] | 178 | 5
Ravens, Baltimore BAL Def | 152 | 6 |  |  |  |  | 28 TOTAL PLAYERS
28 TOTAL PLAYERS
I have: | 1.01 | 1.14 | 1.15 | 2.01 | 3.01 | 4.01
Dorks has: | 1.04 | 1.1 | 1.13 | 2.04 | 3.04 | 3.13
 |  | Rath | Miyagi |  |  | Miyagi