Spreadsheet: 697176d1601232007-trim-and-substitute-cant-help-me-data-example-1-
Sheet: Example data

Team | Rec | Yds | Yds/Rec | TD | 20+ | 40+ | Lng | Rec 1st | Rec 1st% | Rec FUM | PDef |  |  |  |  |  |  | finding out the lenth | using trim | len after using trim | using trim and substitute | len after using trim and substitute
_x000D_  _x000D_ _x000D_ 49ers _x000D_ _x000D_ 49ers | 47 | 409 | 8.7 | 2 | 3 | 0 | 33 | 22 | 46.8 | 1 | 8
Bears | 49 | 538 | 11 | 1 | 8 | 0 | 32 | 29 | 59.2 | 0 | 10
_x000D_  _x000D_ _x000D_ Bengals _x000D_ _x000D_ Bengals | 32 | 427 | 13.3 | 2 | 6 | 1 | 43T | 19 | 59.4 | 0 | 6
_x000D_  _x000D_ _x000D_ Bills _x000D_ _x000D_ Bills | 52 | 543 | 10.4 | 3 | 7 | 1 | 69T | 28 | 53.8 | 1 | 11
_x000D_  _x000D_ _x000D_ Broncos _x000D_ _x000D_ Broncos | 58 | 560 | 9.7 | 4 | 6 | 1 | 84T | 32 | 55.2 | 0 | 10
_x000D_  _x000D_ _x000D_ [NAME] _x000D_ _x000D_ [NAME] | 58 | 600 | 10.3 | 6 | 6 | 1 | 47 | 36 | 62.1 | 0 | 7
_x000D_  _x000D_ _x000D_ Buccaneers _x000D_ _x000D_ Buccaneers | 52 | 565 | 10.9 | 2 | 5 | 1 | 46 | 28 | 53.8 | 1 | 8
_x000D_  _x000D_ _x000D_ Cardinals _x000D_ _x000D_ Cardinals | 38 | 482 | 12.7 | 3 | 6 | 2 | 76T | 20 | 52.6 | 0 | 6
_x000D_  _x000D_ _x000D_ Chargers _x000D_ _x000D_ Chargers | 50 | 495 | 9.9 | 2 | 3 | 1 | 54T | 29 | 58 | 0 | 8
_x000D_  _x000D_ _x000D_ Chiefs _x000D_ _x000D_ Chiefs | 42 | 564 | 13.4 | 2 | 8 | 0 | 35 | 27 | 64.3 | 1 | 5
_x000D_  _x000D_ _x000D_ Colts _x000D_ _x000D_ Colts | 30 | 286 | 9.5 | 3 | 4 | 0 | 28 | 16 | 53.3 | 0 | 9
_x000D_  _x000D_ _x000D_ Cowboys _x000D_ _x000D_ Cowboys | 44 | 548 | 12.5 | 4 | 10 | 1 | 42T | 27 | 61.4 | 0 | 8
_x000D_  _x000D_ _x000D_ [NAME] _x000D_ _x000D_ [NAME] | 69 | 845 | 12.2 | 4 | 11 | 3 | 47 | 37 | 53.6 | 2 | 8
_x000D_  _x000D_ _x000D_ Eagles _x000D_ _x000D_ Eagles | 37 | 445 | 12 | 4 | 7 | 0 | 28T | 28 | 75.7 | 0 | 4
_x000D_  _x000D_ _x000D_ Falcons _x000D_ _x000D_ Falcons | 65 | 772 | 11.9 | 5 | 10 | 1 | 58 | 35 | 53.8 | 1 | 5
_x000D_  _x000D_ _x000D_ Football Team _x000D_ _x000D_ Football Team | 50 | 556 | 11.1 | 3 | 8 | 3 | 55 | 26 | 52 | 1 | 4
_x000D_  _x000D_ _x000D_ Giants _x000D_ _x000D_ Giants | 39 | 419 | 10.7 | 5 | 3 | 0 | 28T | 25 | 64.1 | 1 | 8
_x000D_  _x000D_ _x000D_ [NAME] _x000D_ _x000D_ [NAME] | 72 | 762 | 10.6 | 7 | 6 | 1 | 63 | 38 | 52.8 | 0 | 7
_x000D_  _x000D_ _x000D_ Jets _x000D_ _x000D_ Jets | 55 | 514 | 9.3 | 4 | 4 | 0 | 29 | 29 | 52.7 | 0 | 9
_x000D_  _x000D_ _x000D_ Lions _x000D_ _x000D_ Lions | 38 | 482 | 12.7 | 5 | 7 | 1 | 41 | 28 | 73.7 | 0 | 7
_x000D_  _x000D_ _x000D_ Packers _x000D_ _x000D_ Packers | 39 | 503 | 12.9 | 4 | 8 | 0 | 37T | 22 | 56.4 | 0 | 5
_x000D_  _x000D_ _x000D_ Panthers _x000D_ _x000D_ Panthers | 45 | 456 | 10.1 | 2 | 6 | 2 | 50 | 22 | 48.9 | 0 | 6
_x000D_  _x000D_ _x000D_ Patriots _x000D_ _x000D_ Patriots | 41 | 479 | 11.7 | 5 | 5 | 1 | 54T | 22 | 53.7 | 0 | 6
_x000D_  _x000D_ _x000D_ Raiders _x000D_ _x000D_ Raiders | 48 | 581 | 12.1 | 2 | 4 | 1 | 75T | 30 | 62.5 | 0 | 8
_x000D_  _x000D_ _x000D_ [NAME] _x000D_ _x000D_ [NAME] | 51 | 508 | 10 | 1 | 4 | 0 | 33 | 27 | 52.9 | 0 | 9
_x000D_  _x000D_ _x000D_ Ravens _x000D_ _x000D_ Ravens | 46 | 464 | 10.1 | 2 | 6 | 0 | 38 | 25 | 54.3 | 1 | 9
_x000D_  _x000D_ _x000D_ Saints _x000D_ _x000D_ Saints | 51 | 523 | 10.3 | 5 | 6 | 0 | 37 | 28 | 54.9 | 0 | 8
_x000D_  _x000D_ _x000D_ [NAME] _x000D_ _x000D_ Seahawks | 67 | 847 | 12.6 | 3 | 9 | 2 | 49 | 45 | 67.2 | 0 | 10
_x000D_  _x000D_ _x000D_ Steelers _x000D_ _x000D_ Steelers | 45 | 555 | 12.3 | 4 | 7 | 2 | 45 | 28 | 62.2 | 0 | 10
_x000D_  _x000D_ _x000D_ Texans _x000D_ _x000D_ Texans | 42 | 415 | 9.9 | 4 | 3 | 0 | 29 | 27 | 64.3 | 0 | 5
_x000D_  _x000D_ _x000D_ Titans _x000D_ _x000D_ Titans | 52 | 555 | 10.7 | 4 | 6 | 1 | 45 | 32 | 61.5 | 2 | 12
_x000D_  _x000D_ _x000D_ Vikings _x000D_ _x000D_ Vikings | 51 | 578 | 11.3 | 5 | 9 | 2 | 45T | 27 | 52.9 | 0 | 3