We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Serial number converter

asked 2020-07-30 14:29:04 +0200

voodoo88x gravatar image

updated 2020-08-10 22:21:48 +0200

Alex Kemp gravatar image

I would like to create a converter. This converter would allow me to remove the first 7 digits/characters and the last 5 digits of a serial number. All my serial numbers have 28 digits/characters.

Example : 1TYE216317735144407274700100 would become 3177351444072747

Can someone help me with this one?


David Hayes

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-07-30 14:34:25 +0200

Opaque gravatar image

updated 2020-07-30 14:43:48 +0200


=MID(A1;8;16) (assuming your serial number is in cell A1)
=REGEX(A1;".{7}(.{16}).{5}";"$1") (for friends of regular expressions).

Hope that helps.

edit flag offensive delete link more


Thank you so much! It is greatly appreciated.

voodoo88x gravatar imagevoodoo88x ( 2020-07-30 14:43:03 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-30 14:29:04 +0200

Seen: 82 times

Last updated: Jul 30 '20