Subdivide String

[Mahran]

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

[Or · Accepted solution]

Left(String,8) & '-' & Mid(String,9,4) & '-' etc.

[Mahran]

Thank you!