Removing the last two digits of a cell
Hi guys, I've got a list of 16 digit numbers and I want to remove the last two digits from each one. I am totally stuck as to how I can do this. Can't use find and replace as the numbers are totally random. Is there a function or option that can do this? Thanks Kestrel -- kestrel ------------------------------------------------------------------------ kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082 View this thread: http://www.excelforum.com/showthread...hreadid=542957 |
Removing the last two digits of a cell
in an adjacent column
=left(a1,14) and copy down -- HTH Bob Phillips (remove xxx from email address if mailing direct) "kestrel" wrote in message ... Hi guys, I've got a list of 16 digit numbers and I want to remove the last two digits from each one. I am totally stuck as to how I can do this. Can't use find and replace as the numbers are totally random. Is there a function or option that can do this? Thanks Kestrel -- kestrel ------------------------------------------------------------------------ kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082 View this thread: http://www.excelforum.com/showthread...hreadid=542957 |
Removing the last two digits of a cell
=INT(A1/100)
where A1 is the number Note: 16-digit #s are stored as 15-digits with the last one being a 0. "kestrel" wrote: Hi guys, I've got a list of 16 digit numbers and I want to remove the last two digits from each one. I am totally stuck as to how I can do this. Can't use find and replace as the numbers are totally random. Is there a function or option that can do this? Thanks Kestrel -- kestrel ------------------------------------------------------------------------ kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082 View this thread: http://www.excelforum.com/showthread...hreadid=542957 |
Removing the last two digits of a cell
If you want to remove the last 2 digits (avoiding rounding issues) and want
to keep it a number, you might want to try: =--LEFT(B1,14) -- Kevin Vaughn "Bob Umlas, Excel MVP" wrote: =INT(A1/100) where A1 is the number Note: 16-digit #s are stored as 15-digits with the last one being a 0. "kestrel" wrote: Hi guys, I've got a list of 16 digit numbers and I want to remove the last two digits from each one. I am totally stuck as to how I can do this. Can't use find and replace as the numbers are totally random. Is there a function or option that can do this? Thanks Kestrel -- kestrel ------------------------------------------------------------------------ kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082 View this thread: http://www.excelforum.com/showthread...hreadid=542957 |
All times are GMT +1. The time now is 02:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com