special format from 1 cell

[sinik]

Hello, i need some help to get a specific format starting from 1 cell

for example cell A1 is:

23001A22R9

cell B1 needs to become:

23001A0022/00R009

bot for example cell A2 is:

23001A222R99

cell B2 needs to become:

23001A0222/00R099

So, there always needs to be 5 numbers followed by a letter followed by 4 numbers followed by / followed by 2 numbers followed by a letter followed by 3 numbers. And whe there is a missing number, it needs to be a 0

thanks to anyone who will help me with this!!!!!!!!!!

[Norie]

Will the 'A' and the 'R' always be there?

[sinik]

Hello,

no, some data to help:

23013A145Z9
23013A148L
23013A148N
23013A148R
23017D245W
23017D257W2
23027B80A11
23027B80A12
23027B80A13
23027B80A14

by the way, it can happen that there is no number after the last letter, like here: 23013A148L in this case, there still has to be 3 numbers at the end, so in this case it should be: 23013A0148/00L000

[kev_]

Try this UDF

Use like a formula
=RegexMatch(A1)

Attached file has worked examples

RegexForSinik.jpg

.

Code goes in standard module:

Please Login or Register  to view this content.

This is based on what you provided in post#1 as results

If not what you want for items listed in post#3 then please list expected results for each item
23013A145Z9
23013A148L
23013A148N
23013A148R
23017D245W
23017D257W2
23027B80A11
23027B80A12
23027B80A13
23027B80A14

[sinik]

thank you so much, that's perfect!!!!

[kev_]

Please click ThreadTools@TopOfThread to mark thread SOLVED
Thanks for rep