Serial number converter

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


=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.

Thank you so much! It is greatly appreciated.