Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an ID e.g. CG45984G1156GD42R46Z135466
and now I want to subdivide it as follows:
CG45984G-1156-GD42-R46Z135466
So first after 8 characters should be a '-', then after 4 characters a '-' and then again after 4 characters a '-' and then the rest.
Can anyone help me? Thank you
Left(String,8) & '-' & Mid(String,9,4) & '-' etc.
Thank you!