Jan 23 2021 11:32 AM
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
Jan 23 2021 11:54 AM
@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.
Jan 23 2021 11:58 AM
Jan 23 2021 12:12 PM
@steendanskbaneservice Like this then, but even more ugly. See attached.
Jan 23 2021 01:49 PM
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