=left(a1,13)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"cwd58" <cwd58@discussions.microsoft.com> wrote in message
news:BF4F15CB-0410-4013-9AF1-52398CE86B63@microsoft.com...
> I want to remove the check-digit from a list of barcode numbers. So
> 33609005000160 will be changed to 3360900500016.
>
> Can this be done in Excel or Access?
Bookmarks