Ask Your Question
0

Serial number converter

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

voodoo88x 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?

Thanks!

David Hayes

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

Opaque gravatar image

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

Hello,

=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

Comments

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

Stats

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

Seen: 25 times

Last updated: Jul 30