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

%3CLINGO-SUB%20id%3D%22lingo-sub-2090326%22%20slang%3D%22en-US%22%3EI%20want%20to%20convert%20the%20value%20from%20row%20A%20after%207th%20digit%20to%20year%20and%20version%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090326%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22hhB0V%22%3E%3CDIV%20class%3D%22j1iyq%20hide-focus-ring%22%3E%3CSPAN%20class%3D%22target-language%22%3EEngelsk%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%20class%3D%22tw-ta-container%20hide-focus-ring%20tw-nfl%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22tw-ta-container%20hide-focus-ring%20tw-nfl%22%3E%3CPRE%3E%3CSPAN%3EI%20want%20to%20convert%20the%20value%20from%20row%20A%20after%207th%20digit%20to%20year%20and%20version%20text%20to%20row%20B%20and%20can%20not%20find%20and%20write%20the%20function%3C%2FSPAN%3E%3C%2FPRE%3E%3CPRE%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tw-menu%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22QmZWSe%22%3E%3CDIV%20class%3D%22DHcWmd%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22oSioSc%22%3E%3CDIV%3E%3CDIV%20class%3D%22g9WsWb%22%3E%3CDIV%20class%3D%22tw-ta-container%20hide-focus-ring%20tw-nfl%22%3E%3CPRE%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2090326%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2090357%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20convert%20the%20value%20from%20row%20A%20after%207th%20digit%20to%20year%20and%20version%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090357%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F940181%22%20target%3D%22_blank%22%3E%40steendanskbaneservice%3C%2FA%3E%26nbsp%3BI%20created%20quite%20an%20ugly%20formula%2C%20but%20don't%20really%20understand%20why%20a%20number%201%20should%20be%20the%20Second%20version.%20Anyhow%2C%20it's%20an%20example%20of%20how%20it%20could%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2090359%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20convert%20the%20value%20from%20row%20A%20after%207th%20digit%20to%20year%20and%20version%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090359%22%20slang%3D%22en-US%22%3EDear%20Riny%20thank%20you%20for%20replay%20-%20because%20those%20without%20-x%20are%20the%20first%20version%20and%20-1%20is%20the%20second%20version%2C%20etc.%20kinde%20regards%20steen%20ejlsborg%20-%20Denmark%3C%2FLINGO-BODY%3E
New Contributor
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
 
 
 
 
4 Replies

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

 

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

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

 

@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