I want to convert the value from row A after 7th digit to year and version text

[steendanskbaneservice]

Engelsk

I want to convert the value from row A after 7th digit to year and version text to row B and can not find and write the function

[#2]

@steendanskbaneservice I created quite an ugly formula, but don't really understand why a number 1 should be the Second version. Anyhow, it's an example of how it could work.

[#3]

Dear Riny thank you for replay - because those without -x are the first version and -1 is the second version, etc. kinde regards steen ejlsborg - Denmark

[#4]

@steendanskbaneservice Like this then, but even more ugly. See attached.

[#5]

@Riny_van_Eekelen 

Thank you. -  You are a star by me

it work very well :)

Now i will se in the TV if the Dane has beaten the janpanese in handbold 

Kind regards

Steen Ejlsborg