Mid left and Right

[vmjan02]

can this 2 output can be done

Book1
	A	B	C
1	Input	Output 1	Output 2
2	00-18-82-B8-09-72	0018-82b8-0972	0018.82b8.0972
3	00-18-82-B8-1C-CE	0018-82B8-1CCE	0018.82B8.1CCE
4	00-18-82-B8-1C-D0	0018-82B8-1CD0	0018.82B8.1CD0
5	00-18-82-B8-09-7E	0018-82B8-097E	0018.82B8.097E
6	00-18-82-97-A7-86	0018-8297-A786	0018.8297.A786
7	5c-4c-a9-17-21-a1	5c4c-a917-21a1	5c4c.a917.21a1
8	5c-4c-a9-16-b5-6d	5c4c-a916-b56d	5c4c.a916.b56d
9	38-4c-4f-a6-6f-4b	384c-4fa6-6f4b	384c.4fa6.6f4b
10	5c-4c-a9-17-2c-e0	5c4c-a917-2ce0	5c4c.a917.2ce0
11	70-7b-e8-52-c5-6e	707b-e852-c56e	707b.e852.c56e
12	70-7b-e8-5f-64-47	707b-e85f-6447	707b.e85f.6447
13	70-7b-e8-5f-66-85	707b-e85f-6685	707b.e85f.6685
14	38-4c-4f-65-7c-7f	384c-4f65-7c7f	384c.4f65.7c7f
15	c8-8d-83-13-63-34	c88d-8313-6334	c88d.8313.6334
Sheet1

 

[RoryA]

I like this game

=TEXTJOIN("-",,MID(A2,{1,7,13},2)&MID(A2,{4,10,16},2))

and

=TEXTJOIN(".",,MID(A2,{1,7,13},2)&MID(A2,{4,10,16},2))

 

[Georgiboy]

With formula and VBA, this is my favourite game

 

[vmjan02]

Ok thanks guys will check for sure.