how to remove last two alphabets from numberics

[sivanandan dinesh]

how to remove last two alphabets from numberics out of the following combination ? <table width="122" border="0" cellpadding="0" cellspacing="0" height="18"><col width="122"><tr height="17"> <td class="xl66" style="height: 12.75pt; width: 92pt;" width="122" height="17"> <table width="107" border="0" cellpadding="0" cellspacing="0"><col style="width: 80pt;" width="107"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 80pt;" width="107" height="17">334,038,639.69Dr</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">334,030,639.69Dr</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">334,010,639.69Dr</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">333,998,139.69Dr</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">333,933,643.69Dr</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">333,919,652.69Dr</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">333,909,652.69Dr</td> </tr> </tbody></table></td> </tr></table>

 

[VoG]

Try

=LEFT(A1,LEN(A1)-2)+0

 

[JackDanIce]

Welcome to the board.

Will your data always end in 2 alphabet characters or do you always want to remove the last 2 characters regardless?

If the latter, try:

=VALUE(LEFT(A1,LEN(A1)-2))

 

[Airfix9]

In the cell or in an adjacent cell?

If you just want to remove the Dr, use Edit and Replace (CTRL+H), replacing Dr with nothing

If you want it in the next cell, assuming your data is in column A, edit this to suit:

=VALUE(SUBSTITUTE(A1,"Dr",""))

 

[sivanandan dinesh]

Thank u verymuch for your wonderful suggestion. It worked and my problem solved.
Thank u & regards
dinesh.