delating extra letters and numbers

[wolf735]

Hello, i'm having trouble deleting extra letters and or numbers form my data sets. how delete extra data without "corrupting" data. this is an example of data im using.

<table style="border-collapse: collapse; width: 48pt;" width="64" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt; width: 48pt;" width="64" height="20">Arabic I</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Arabic Ii</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Chinese Ii</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Crime Scene Investigation</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Food Preparation</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">French I</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">French Ii</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">German I</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Hindi I</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Hindi Ii</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Indonesian I</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Indonesian Ii</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Italian I</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl70" style="height: 15pt;" height="20">Italian Ii</td><td valign="top">
</td><td valign="top">
</td><td valign="top">
</td> </tr> </tbody></table>my problem is i have no clue as to how to get the extra i's at end out.
<table style="border-collapse: collapse; width: 48pt;" width="64" border="0" cellpadding="0" cellspacing="0"><tbody></tbody></table>

 

[xld]

Try

=IF(RIGHT(A2,2)="Ii",LEFT(A2,LEN(A2)-1),A2)

 

[gsbelbin]

You could try

=IF(RIGHT(A1,1)="i",LEFT(A1,LEN(A1)-1),A1)

Note that this will not allow for cells that contain something like Hindi. It just looks for an i at the end

 

[wolf735]

i tryed both ways got ether (0) or (#value!)

 

[wolf735]

it worked the computer was having user errors sorry guys and thanks

 

[bosco_yip]

Or, this :

=SUBSTITUTE(A1,"Ii","I")

Regards

 

[xld]

Or, this :

=SUBSTITUTE(A1,"Ii","I")

Regards

HE said ... how to get the extra i's at end ...