Translate sequence of numbers to another sequence of numbers

[rbylin]

Hi

I need to translate a seuqence of numbers 01000988 to another sequence format, 0010-01-0988 were the part 0010 is matched to the first four symbols of 01000988 the 01 is just Always 01 and 0988 should match the last 4 of 01000988

this is what I want the results to be

01000988 = 0010-01-0988
01000989 = 0010-01-0989

03400789 = 0034-01-0789
03401200 = 0034-01-1200

05000365 = 0050-01-0365

 

[JackDanIce]

Welcome to the board.

Your example suggests first 4 parts of the sequence are 0 & first left 3 chars of the original string

01000988 = 0010-01-0988
01000989 = 0010-01-0989

03400789 = 0034-01-0789
03401200 = 0034-01-1200

05000365 = 0050-01-0365

vs

were the part 0010 is matched to the first four symbols of 01000988

Which doesn't match your provided example.

This works for the examples provided

="0"&LEFT(A1,3) & "-01-"&RIGHT(A1,4)

 

[footoo]

Perhaps : =TEXT(LEFT(A1,LEN(A1)-5),"0000") & "-01-" & RIGHT(A1,4)

 

[rbylin]

Welcome to the board.

Your example suggests first 4 parts of the sequence are 0 & first left 3 chars of the original string

vs
Which doesn't match your provided example.

This works for the examples provided

="0"&LEFT(A1,3) & "-01-"&RIGHT(A1,4)

Thank you :D late answer but still! just had to translate the functions to swedish to get it to work :P

Looks like this, ="0"&VÄNSTER(A1;3) & "-01-"&HÖGER(A1;4)