I'm now working ona very ugly solution but having issues.
=RIGHT(LEFT(H65,7)&RIGHT(LEFT(H65,8))&RIGHT(LEFT(H65,9))&RIGHT(LEFT(H65,10))&RIGHT(LEFT(H65,6))&RIGHT(LEFT(H65,4))&RIGHT(LEFT(H65,5))&RIGHT(LEFT(H65,3))&RIGHT(LEFT(H65,1))&RIGHT(LEFT(H65,2)),LEN(H65))
this is generating .03.22
I'm getting there. I think there is a lot of white space at the end of the year so may need to trim first?
from left to right
data:2 2 . 0 3 . 1 9 8 2
char:1 2 3 4 5 6 7 8 9 10
sequence reqd:
7 8 9 10 | 6 | 4 5 | 3 | 1 2
Bookmarks