how to remove last two alphabets from numberics

sivanandan dinesh

New Member
Joined
Mar 16, 2011
Messages
4
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>
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,685
Office Version
  1. 365
Platform
  1. Windows
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))
 

Airfix9

Well-known Member
Joined
Sep 23, 2005
Messages
886
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",""))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,538
Messages
5,529,429
Members
409,876
Latest member
Akash Yadav
Top