formula for Dashes between the text

[geniusufo007]

Dear all,
I need a formula which place dashes in the text as shown in the attachment.

IT2021090901011166910
the above must be like the below one
IT-20210909-0101-1166910

[AliGW]

This:

=LEFT(A2,2)&"-"&MID(A2,3,8)&"-"&MID(A2,11,4)&"-"&MID(A2,15,8)

AliGW on MS365 Insider (Windows) 64 bit

	A	B
1	CPR No
2	IT2021061701011379530	IT-20210617-0101-1379530
3	IT2020031300551196951	IT-20200313-0055-1196951
4	IT2020031300551196951	IT-20200313-0055-1196951
5	IT2020031300551196951	IT-20200313-0055-1196951
6	IT2020061610561212126	IT-20200616-1056-1212126
7	IT2020100801011129701	IT-20201008-0101-1129701
8	IT2020100801011129703	IT-20201008-0101-1129703
9	IT2020111201011184670	IT-20201112-0101-1184670
10	IT2020111201011184670	IT-20201112-0101-1184670
11	IT2020111201011184670	IT-20201112-0101-1184670
12	IT2021031601011481393	IT-20210316-0101-1481393
13	IT2021031601011481393	IT-20210316-0101-1481393
14	IT2021031601011481393	IT-20210316-0101-1481393
15	IT2021041701011325038	IT-20210417-0101-1325038
16	IT2021052001011215010	IT-20210520-0101-1215010
17	IT2021052001011216958	IT-20210520-0101-1216958
18	IT2021061001011206037	IT-20210610-0101-1206037
19	IT2021063001011663713	IT-20210630-0101-1663713
20	IT2021080401011059222	IT-20210804-0101-1059222
21	IT2021090901011166932	IT-20210909-0101-1166932
22	IT2021090901011166910	IT-20210909-0101-1166910

Sheet: Total Paid Amount

[geniusufo007]

sorry it is working

[AliGW]

That's what I've done ...

[geniusufo007]

Thank you very much

[AliGW]

If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.