# how to remove last two alphabets from numberics

#### sivanandan dinesh

##### New Member
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>

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Try

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

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:
Code:
``=VALUE(LEFT(A1,LEN(A1)-2))``

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",""))

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

Replies
8
Views
409
Replies
7
Views
2K
Replies
0
Views
828
Replies
1
Views
163
Replies
2
Views
1K

1,221,209
Messages
6,158,550
Members
451,498
Latest member
tyshanklin1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back