<table x:str="" style="border-collapse: collapse; width: 375pt;" border="0" cellpadding="0" cellspacing="0" width="500"> <col style="width: 87pt;" width="116"> <col span="6" style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 87pt;" height="17" width="116">Player</td> <td class="xl24" style="width: 48pt;" width="64">Pos</td> <td class="xl24" style="width: 48pt;" width="64">Team</td> <td class="xl24" style="width: 48pt;" width="64">Dr</td> <td class="xl24" style="width: 48pt;" width="64">p</td> <td class="xl24" style="width: 48pt;" width="64">PPly</td> <td class="xl24" style="width: 48pt;" width="64">TPct</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Carach, Renaldo</td> <td class="xl24">WR</td> <td class="xl24">PIT</td> <td class="xl24" x:num="">6</td> <td class="xl24">
</td> <td class="xl24">490 3</td> <td class="xl24" x:num="">3.2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Jenkins, Jamal</td> <td class="xl24">WR</td> <td class="xl24">DEN</td> <td class="xl24" x:num="">7</td> <td class="xl24">
</td> <td class="xl24">522 3</td> <td class="xl24" x:num="">0.4</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Beattie, Vince</td> <td class="xl24">TE</td> <td class="xl24">STL</td> <td class="xl24" x:num="">8</td> <td class="xl24">
</td> <td class="xl24">506 2</td> <td class="xl24" x:num="">8.8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Jacobson, Andrew</td> <td class="xl24">WR</td> <td class="xl24">PHI</td> <td class="xl24" x:num="">16</td> <td class="xl24">
</td> <td class="xl24">428 3</td> <td class="xl24" x:num="">4.5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">DeVore, Donald</td> <td class="xl24">WR</td> <td class="xl24">MIN</td> <td class="xl24" x:num="">8</td> <td class="xl24">
</td> <td class="xl24">434 3</td> <td class="xl24" x:num="">2.2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Prior, Corey</td> <td class="xl24">WR</td> <td class="xl24">SFO</td> <td class="xl24" x:num="">5</td> <td class="xl24">
</td> <td class="xl24">526 2</td> <td class="xl24" x:num="">7.7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Cumming, Juan</td> <td class="xl24">WR</td> <td class="xl24">JAX</td> <td class="xl24" x:num="">11</td> <td class="xl24">
</td> <td class="xl24">424 3</td> <td class="xl24" x:num="">6.5</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Colloran, Adam</td> <td class="xl24">WR</td> <td class="xl24">IND</td> <td class="xl24" x:num="">9</td> <td class="xl24">
</td> <td class="xl24">406 3</td> <td class="xl24" x:num="">3.7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Tanaka, Burt</td> <td class="xl24">TE</td> <td class="xl24">ANA</td> <td class="xl24" x:num="">6</td> <td class="xl24">
</td> <td class="xl24">490 2</td> <td class="xl24" x:num="">6.9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Val, Desmond</td> <td class="xl24">WR</td> <td class="xl24">ARI</td> <td class="xl24" x:num="">8</td> <td class="xl24">
</td> <td class="xl24">545 2</td> <td class="xl24" x:num="">4.9</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Clark, Jeremy</td> <td class="xl24">FB</td> <td class="xl24">GBY</td> <td class="xl24" x:num="">6</td> <td class="xl24">
</td> <td class="xl24">419 2</td> <td class="xl24" x:num="">7.6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Farmer, Vince</td> <td class="xl24">WR</td> <td class="xl24">DET</td> <td class="xl24" x:num="">4</td> <td class="xl24">
</td> <td class="xl24">414 3</td> <td class="xl24" x:num="">1.8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Donhoff, Martin</td> <td class="xl24">FB</td> <td class="xl24">ARI</td> <td class="xl24" x:num="">6</td> <td class="xl24">
</td> <td class="xl24">440 2</td> <td class="xl24" x:num="">5.6</td> </tr></tbody> </table>
Carach should have a TPct of 33.2, Jenkins should be 30.4, and so on down the line. I'm going to have roughly 2,200 of these, so doing them by hand isn't an option. Is there a quick way to clean these up?

I assume the PPLY last digit is what you want?

Assume PPLY column is column A and Tpct is Column B, so in Column C (new column) in C1 put:

=Right(A1,1)&b1

This should combine the last number from PPLY and the number in TPCT. Copy and paste all the way down.

I assume the PPLY last digit is what you want?

Assume PPLY column is column A and Tpct is Column B, so in Column C (new column) in C1 put:

=Right(A1,1)&b1

This should combine the last number from PPLY and the number in TPCT. Copy and paste all the way down.Trying that now...

ACtually, for the calculations I intend to do, I need PPly, but not really TPct.

ACtually, for the calculations I intend to do, I need PPly, but not really TPct.

So if you need PPLY, assuming they are all 3 digit numbers, you could do something like this on that column to isolate those digits:

=Left(a1,3)

Yeah...figured that out....works like a charm. THANKS!!!!