Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field which contain 17 digits i will like to split it.
turn this:
00120190139007009
into this:
001201-9-0139-007-00-9
as below
=left(fieldname,6)&'-'&mid(fieldname,7,1)&'-'&mid(fieldname,8,4)&'-'&mid(fieldname,12,3)&'-'&mid(fieldname,15,2)&'-'&right(fieldname,1)
as below
=left(fieldname,6)&'-'&mid(fieldname,7,1)&'-'&mid(fieldname,8,4)&'-'&mid(fieldname,12,3)&'-'&mid(fieldname,15,2)&'-'&right(fieldname,1)