Or:
=REPLACE(TEXT(SUM(ABS(10^{2,0}*((1+LEN(G6)-LEN(SUBSTITUTE(G6,"-","")))*{0,1}-SUMPRODUCT(--((--TRIM(MID(SUBSTITUTE(G6,"-",REPT(" ",255)),255*(ROW(INDIRECT("1:"&1+LEN(G6)-LEN(SUBSTITUTE(G6,"-",""))))-1)+1,255)))<=18))))),"000"),2,1,"/")
Regards
Or:
=REPLACE(TEXT(SUM(ABS(10^{2,0}*((1+LEN(G6)-LEN(SUBSTITUTE(G6,"-","")))*{0,1}-SUMPRODUCT(--((--TRIM(MID(SUBSTITUTE(G6,"-",REPT(" ",255)),255*(ROW(INDIRECT("1:"&1+LEN(G6)-LEN(SUBSTITUTE(G6,"-",""))))-1)+1,255)))<=18))))),"000"),2,1,"/")
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks