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