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

 

[Georgiboy]

Maybe:

Book1
	A	B	C
1	Input
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

Cell Formulas
Range	Formula
B2:B15	B2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-","",1),"-","",2),"-","",3)
C2:C15	C2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-","",1),"-","",2),"-","",3),"-",".")

 

[RoryA]

The second one is basically the same as your previous question:

=SUBSTITUTE(LEFT(B2,5)&"."&MID(B2,7,5)&"."&RIGHT(B2,5),"-","")

 

[vmjan02]

Maybe:

Book1
	A	B	C
1	Input
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

Cell Formulas
Range	Formula
B2:B15	B2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-","",1),"-","",2),"-","",3)
C2:C15	C2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-","",1),"-","",2),"-","",3),"-",".")

thanks a ton.

 

[vmjan02]

The second one is basically the same as your previous question:

=SUBSTITUTE(LEFT(B2,5)&"."&MID(B2,7,5)&"."&RIGHT(B2,5),"-","")

ok i think i missed it, no problem

 

[vmjan02]

@RoryA and @Georgiboy

Data is behaving very differntly my bad sorry but can this be fixed in a single formula as I am been working on it more than 5 hrs now.

Book4
	A	B	C	D
1	Input	Output 1	Output 2	Remarks
2	5c-4c-a9-17-21-a1	5c4c-a917-21a1	5c4c.a917.21a1
3	5c-4c-a9-16-b5-6d	5c4c-a916-b56d	5c4c.a916.b56d
4	38-4c-4f-a6-6f-4b	384c-4fa6-6f4b	384c.4fa6.6f4b
5	5c-4c-a9-17-2c-e0	5c4c-a917-2ce0	5c4c.a917.2ce0
6	70-7b-e8-52-c5-6e	707b-e852-c56e	707b.e852.c56e
7	70-7b-e8-5f-64-47	707b-e85f-6447	707b.e85f.6447
8	70-7b-e8-5f-66-85	707b-e85f-6685	707b.e85f.6685
9	38-4c-4f-65-7c-7f	384c-4f65-7c7f	384c.4f65.7c7f
10	c8-8d-83-13-63-34	c88d-8313-6334	c88d.8313.6334
11	70-7b-e8-5f-5d-db	707b-e85f-5ddb	707b.e85f.5ddb
12	5c-4c-a9-17-30-8e	5c4c-a917-308e	5c4c.a917.308e
13	00:19:8F:63:24:6C	00:19:8F:63:24:6C	00:19:8F:63:24:6C	Problem
14	E0:30:05:E2:F8:C5	E0:30:05:E2:F8:C5	E0:30:05:E2:F8:C5	Problem
15	00:19:8F:60:63:90	00:19:8F:60:63:90	00:19:8F:60:63:90	Problem
16	00:19:8F:62:0E:33	00:19:8F:62:0E:33	00:19:8F:62:0E:33	Problem
17	00:19:8F:80:7B:06	00:19:8F:80:7B:06	00:19:8F:80:7B:06	Problem
18	00:19:8F:80:90:1F	00:19:8F:80:90:1F	00:19:8F:80:90:1F	Problem
19	00:19:8F:80:97:E6	00:19:8F:80:97:E6	00:19:8F:80:97:E6	Problem
20	00:19:8F:80:70:D7	00:19:8F:80:70:D7	00:19:8F:80:70:D7	Problem
21	00:19:8F:80:90:2A	00:19:8F:80:90:2A	00:19:8F:80:90:2A	Problem
22	00:19:8F:80:97:6D	00:19:8F:80:97:6D	00:19:8F:80:97:6D	Problem
23	00:19:8F:80:80:65	00:19:8F:80:80:65	00:19:8F:80:80:65	Problem
24	00:19:8F:80:5D:13	00:19:8F:80:5D:13	00:19:8F:80:5D:13	Problem
25	00-18-82-B8-09-72	0018-82B8-0972	0018.82B8.0972
26	00-18-82-B8-1C-CE	0018-82B8-1CCE	0018.82B8.1CCE
27	00-18-82-B8-1C-D0	0018-82B8-1CD0	0018.82B8.1CD0
28	00-18-82-B8-09-7E	0018-82B8-097E	0018.82B8.097E
29	00-18-82-97-A7-86	0018-8297-A786	0018.8297.A786
30	00-25-9E-56-36-3F	0025-9E56-363F	0025.9E56.363F
31	08-19-A6-F1-E8-A2	0819-A6F1-E8A2	0819.A6F1.E8A2
32	00-25-9E-56-35-91	0025-9E56-3591	0025.9E56.3591
33	00-25-9E-0C-67-50	0025-9E0C-6750	0025.9E0C.6750
34	00-25-9E-93-81-C3	0025-9E93-81C3	0025.9E93.81C3
35	00-25-9E-92-DF-EF	0025-9E92-DFEF	0025.9E92.DFEF
36	00-25-9E-22-3C-93	0025-9E22-3C93	0025.9E22.3C93
37	00:19:8F:60:0C:4B	00:19:8F:60:0C:4B	00:19:8F:60:0C:4B	Problem
38	00:07:72:82:C0:3F	00:07:72:82:C0:3F	00:07:72:82:C0:3F	Problem
39	00:07:72:7D:28:53	00:07:72:7D:28:53	00:07:72:7D:28:53	Problem
40	00:07:72:56:1C:BB	00:07:72:56:1C:BB	00:07:72:56:1C:BB	Problem
41	00:19:8F:2F:D1:E5	00:19:8F:2F:D1:E5	00:19:8F:2F:D1:E5	Problem
42	00:07:72:87:51:11	00:07:72:87:51:11	00:07:72:87:51:11	Problem
43	00:07:72:89:53:3D	00:07:72:89:53:3D	00:07:72:89:53:3D	Problem
44	00:07:72:7B:3F:35	00:07:72:7B:3F:35	00:07:72:7B:3F:35	Problem
45	00:07:72:6F:14:2B	00:07:72:6F:14:2B	00:07:72:6F:14:2B	Problem
46	00:07:72:7B:3F:A9	00:07:72:7B:3F:A9	00:07:72:7B:3F:A9	Problem
47	00:19:8F:5F:EB:98	00:19:8F:5F:EB:98	00:19:8F:5F:EB:98	Problem
48	00:19:8F:2F:F4:85	00:19:8F:2F:F4:85	00:19:8F:2F:F4:85	Problem
49	08:9C:86:E5:A1:38	08:9C:86:E5:A1:38	08:9C:86:E5:A1:38	Problem
50	08:9C:86:E5:A1:30	08:9C:86:E5:A1:30	08:9C:86:E5:A1:30	Problem
Sheet1

Cell Formulas
Range	Formula
B2:B50	B2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-","",1),"-","",2),"-","",3)
C2:C50	C2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"-","",1),"-","",2),"-","",3),"-",".")

 

[Georgiboy]

One option might be to add another substitute in the formula:

Book1
	A	B	C
1	Input	Output 1	Output 2
2	5c-4c-a9-17-21-a1	5c4c-a917-21a1	5c4c.a917.21a1
3	5c-4c-a9-16-b5-6d	5c4c-a916-b56d	5c4c.a916.b56d
4	38-4c-4f-a6-6f-4b	384c-4fa6-6f4b	384c.4fa6.6f4b
5	5c-4c-a9-17-2c-e0	5c4c-a917-2ce0	5c4c.a917.2ce0
6	70-7b-e8-52-c5-6e	707b-e852-c56e	707b.e852.c56e
7	70-7b-e8-5f-64-47	707b-e85f-6447	707b.e85f.6447
8	70-7b-e8-5f-66-85	707b-e85f-6685	707b.e85f.6685
9	38-4c-4f-65-7c-7f	384c-4f65-7c7f	384c.4f65.7c7f
10	c8-8d-83-13-63-34	c88d-8313-6334	c88d.8313.6334
11	70-7b-e8-5f-5d-db	707b-e85f-5ddb	707b.e85f.5ddb
12	5c-4c-a9-17-30-8e	5c4c-a917-308e	5c4c.a917.308e
13	00:19:8F:63:24:6C	0019-8F63-246C	0019.8F63.246C
14	E0:30:05:E2:F8:C5	E030-05E2-F8C5	E030.05E2.F8C5
15	00:19:8F:60:63:90	0019-8F60-6390	0019.8F60.6390
16	00:19:8F:62:0E:33	0019-8F62-0E33	0019.8F62.0E33
17	00:19:8F:80:7B:06	0019-8F80-7B06	0019.8F80.7B06
18	00:19:8F:80:90:1F	0019-8F80-901F	0019.8F80.901F
19	00:19:8F:80:97:E6	0019-8F80-97E6	0019.8F80.97E6
20	00:19:8F:80:70:D7	0019-8F80-70D7	0019.8F80.70D7
21	00:19:8F:80:90:2A	0019-8F80-902A	0019.8F80.902A
22	00:19:8F:80:97:6D	0019-8F80-976D	0019.8F80.976D
23	00:19:8F:80:80:65	0019-8F80-8065	0019.8F80.8065
24	00:19:8F:80:5D:13	0019-8F80-5D13	0019.8F80.5D13
25	00-18-82-B8-09-72	0018-82B8-0972	0018.82B8.0972
26	00-18-82-B8-1C-CE	0018-82B8-1CCE	0018.82B8.1CCE
27	00-18-82-B8-1C-D0	0018-82B8-1CD0	0018.82B8.1CD0
28	00-18-82-B8-09-7E	0018-82B8-097E	0018.82B8.097E
29	00-18-82-97-A7-86	0018-8297-A786	0018.8297.A786
30	00-25-9E-56-36-3F	0025-9E56-363F	0025.9E56.363F
31	08-19-A6-F1-E8-A2	0819-A6F1-E8A2	0819.A6F1.E8A2
32	00-25-9E-56-35-91	0025-9E56-3591	0025.9E56.3591
33	00-25-9E-0C-67-50	0025-9E0C-6750	0025.9E0C.6750
34	00-25-9E-93-81-C3	0025-9E93-81C3	0025.9E93.81C3
35	00-25-9E-92-DF-EF	0025-9E92-DFEF	0025.9E92.DFEF
36	00-25-9E-22-3C-93	0025-9E22-3C93	0025.9E22.3C93
37	00:19:8F:60:0C:4B	0019-8F60-0C4B	0019.8F60.0C4B
38	00:07:72:82:C0:3F	0007-7282-C03F	0007.7282.C03F
39	00:07:72:7D:28:53	0007-727D-2853	0007.727D.2853
40	00:07:72:56:1C:BB	0007-7256-1CBB	0007.7256.1CBB
41	00:19:8F:2F:D1:E5	0019-8F2F-D1E5	0019.8F2F.D1E5
42	00:07:72:87:51:11	0007-7287-5111	0007.7287.5111
43	00:07:72:89:53:3D	0007-7289-533D	0007.7289.533D
44	00:07:72:7B:3F:35	0007-727B-3F35	0007.727B.3F35
45	00:07:72:6F:14:2B	0007-726F-142B	0007.726F.142B
46	00:07:72:7B:3F:A9	0007-727B-3FA9	0007.727B.3FA9
47	00:19:8F:5F:EB:98	0019-8F5F-EB98	0019.8F5F.EB98
48	00:19:8F:2F:F4:85	0019-8F2F-F485	0019.8F2F.F485
49	08:9C:86:E5:A1:38	089C-86E5-A138	089C.86E5.A138
50	08:9C:86:E5:A1:30	089C-86E5-A130	089C.86E5.A130
Sheet1

Cell Formulas
Range	Formula
B2:B50	B2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,":","-"),"-","",1),"-","",2),"-","",3)
C2:C50	C2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,":","-"),"-","",1),"-","",2),"-","",3),"-",".")

 

[vmjan02]

One option might be to add another substitute in the formula:

Book1
	A	B	C
1	Input	Output 1	Output 2
2	5c-4c-a9-17-21-a1	5c4c-a917-21a1	5c4c.a917.21a1
3	5c-4c-a9-16-b5-6d	5c4c-a916-b56d	5c4c.a916.b56d
4	38-4c-4f-a6-6f-4b	384c-4fa6-6f4b	384c.4fa6.6f4b
5	5c-4c-a9-17-2c-e0	5c4c-a917-2ce0	5c4c.a917.2ce0
6	70-7b-e8-52-c5-6e	707b-e852-c56e	707b.e852.c56e
7	70-7b-e8-5f-64-47	707b-e85f-6447	707b.e85f.6447
8	70-7b-e8-5f-66-85	707b-e85f-6685	707b.e85f.6685
9	38-4c-4f-65-7c-7f	384c-4f65-7c7f	384c.4f65.7c7f
10	c8-8d-83-13-63-34	c88d-8313-6334	c88d.8313.6334
11	70-7b-e8-5f-5d-db	707b-e85f-5ddb	707b.e85f.5ddb
12	5c-4c-a9-17-30-8e	5c4c-a917-308e	5c4c.a917.308e
13	00:19:8F:63:24:6C	0019-8F63-246C	0019.8F63.246C
14	E0:30:05:E2:F8:C5	E030-05E2-F8C5	E030.05E2.F8C5
15	00:19:8F:60:63:90	0019-8F60-6390	0019.8F60.6390
16	00:19:8F:62:0E:33	0019-8F62-0E33	0019.8F62.0E33
17	00:19:8F:80:7B:06	0019-8F80-7B06	0019.8F80.7B06
18	00:19:8F:80:90:1F	0019-8F80-901F	0019.8F80.901F
19	00:19:8F:80:97:E6	0019-8F80-97E6	0019.8F80.97E6
20	00:19:8F:80:70:D7	0019-8F80-70D7	0019.8F80.70D7
21	00:19:8F:80:90:2A	0019-8F80-902A	0019.8F80.902A
22	00:19:8F:80:97:6D	0019-8F80-976D	0019.8F80.976D
23	00:19:8F:80:80:65	0019-8F80-8065	0019.8F80.8065
24	00:19:8F:80:5D:13	0019-8F80-5D13	0019.8F80.5D13
25	00-18-82-B8-09-72	0018-82B8-0972	0018.82B8.0972
26	00-18-82-B8-1C-CE	0018-82B8-1CCE	0018.82B8.1CCE
27	00-18-82-B8-1C-D0	0018-82B8-1CD0	0018.82B8.1CD0
28	00-18-82-B8-09-7E	0018-82B8-097E	0018.82B8.097E
29	00-18-82-97-A7-86	0018-8297-A786	0018.8297.A786
30	00-25-9E-56-36-3F	0025-9E56-363F	0025.9E56.363F
31	08-19-A6-F1-E8-A2	0819-A6F1-E8A2	0819.A6F1.E8A2
32	00-25-9E-56-35-91	0025-9E56-3591	0025.9E56.3591
33	00-25-9E-0C-67-50	0025-9E0C-6750	0025.9E0C.6750
34	00-25-9E-93-81-C3	0025-9E93-81C3	0025.9E93.81C3
35	00-25-9E-92-DF-EF	0025-9E92-DFEF	0025.9E92.DFEF
36	00-25-9E-22-3C-93	0025-9E22-3C93	0025.9E22.3C93
37	00:19:8F:60:0C:4B	0019-8F60-0C4B	0019.8F60.0C4B
38	00:07:72:82:C0:3F	0007-7282-C03F	0007.7282.C03F
39	00:07:72:7D:28:53	0007-727D-2853	0007.727D.2853
40	00:07:72:56:1C:BB	0007-7256-1CBB	0007.7256.1CBB
41	00:19:8F:2F:D1:E5	0019-8F2F-D1E5	0019.8F2F.D1E5
42	00:07:72:87:51:11	0007-7287-5111	0007.7287.5111
43	00:07:72:89:53:3D	0007-7289-533D	0007.7289.533D
44	00:07:72:7B:3F:35	0007-727B-3F35	0007.727B.3F35
45	00:07:72:6F:14:2B	0007-726F-142B	0007.726F.142B
46	00:07:72:7B:3F:A9	0007-727B-3FA9	0007.727B.3FA9
47	00:19:8F:5F:EB:98	0019-8F5F-EB98	0019.8F5F.EB98
48	00:19:8F:2F:F4:85	0019-8F2F-F485	0019.8F2F.F485
49	08:9C:86:E5:A1:38	089C-86E5-A138	089C.86E5.A138
50	08:9C:86:E5:A1:30	089C-86E5-A130	089C.86E5.A130
Sheet1

Cell Formulas
Range	Formula
B2:B50	B2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,":","-"),"-","",1),"-","",2),"-","",3)
C2:C50	C2	=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,":","-"),"-","",1),"-","",2),"-","",3),"-",".")

Thank you sir, it worekd perfect

 

[Scott Huish]

A bit shorter

Book1
	A	B	C
1	Input	Output 1	Output 2
2	5c-4c-a9-17-21-a1	5c4c-a917-21a1	5c4c.a917.21a1
3	5c-4c-a9-16-b5-6d	5c4c-a916-b56d	5c4c.a916.b56d
4	38-4c-4f-a6-6f-4b	384c-4fa6-6f4b	384c.4fa6.6f4b
5	5c-4c-a9-17-2c-e0	5c4c-a917-2ce0	5c4c.a917.2ce0
6	70-7b-e8-52-c5-6e	707b-e852-c56e	707b.e852.c56e
7	70-7b-e8-5f-64-47	707b-e85f-6447	707b.e85f.6447
8	70-7b-e8-5f-66-85	707b-e85f-6685	707b.e85f.6685
9	38-4c-4f-65-7c-7f	384c-4f65-7c7f	384c.4f65.7c7f
10	c8-8d-83-13-63-34	c88d-8313-6334	c88d.8313.6334
11	70-7b-e8-5f-5d-db	707b-e85f-5ddb	707b.e85f.5ddb
12	5c-4c-a9-17-30-8e	5c4c-a917-308e	5c4c.a917.308e
13	00:19:8F:63:24:6C	0019-8F63-246C	0019.8F63.246C
14	E0:30:05:E2:F8:C5	E030-05E2-F8C5	E030.05E2.F8C5
15	00:19:8F:60:63:90	0019-8F60-6390	0019.8F60.6390
16	00:19:8F:62:0E:33	0019-8F62-0E33	0019.8F62.0E33
17	00:19:8F:80:7B:06	0019-8F80-7B06	0019.8F80.7B06
18	00:19:8F:80:90:1F	0019-8F80-901F	0019.8F80.901F
19	00:19:8F:80:97:E6	0019-8F80-97E6	0019.8F80.97E6
20	00:19:8F:80:70:D7	0019-8F80-70D7	0019.8F80.70D7
21	00:19:8F:80:90:2A	0019-8F80-902A	0019.8F80.902A
22	00:19:8F:80:97:6D	0019-8F80-976D	0019.8F80.976D
23	00:19:8F:80:80:65	0019-8F80-8065	0019.8F80.8065
24	00:19:8F:80:5D:13	0019-8F80-5D13	0019.8F80.5D13
25	00-18-82-B8-09-72	0018-82B8-0972	0018.82B8.0972
26	00-18-82-B8-1C-CE	0018-82B8-1CCE	0018.82B8.1CCE
27	00-18-82-B8-1C-D0	0018-82B8-1CD0	0018.82B8.1CD0
28	00-18-82-B8-09-7E	0018-82B8-097E	0018.82B8.097E
29	00-18-82-97-A7-86	0018-8297-A786	0018.8297.A786
30	00-25-9E-56-36-3F	0025-9E56-363F	0025.9E56.363F
31	08-19-A6-F1-E8-A2	0819-A6F1-E8A2	0819.A6F1.E8A2
32	00-25-9E-56-35-91	0025-9E56-3591	0025.9E56.3591
33	00-25-9E-0C-67-50	0025-9E0C-6750	0025.9E0C.6750
34	00-25-9E-93-81-C3	0025-9E93-81C3	0025.9E93.81C3
35	00-25-9E-92-DF-EF	0025-9E92-DFEF	0025.9E92.DFEF
36	00-25-9E-22-3C-93	0025-9E22-3C93	0025.9E22.3C93
37	00:19:8F:60:0C:4B	0019-8F60-0C4B	0019.8F60.0C4B
38	00:07:72:82:C0:3F	0007-7282-C03F	0007.7282.C03F
39	00:07:72:7D:28:53	0007-727D-2853	0007.727D.2853
40	00:07:72:56:1C:BB	0007-7256-1CBB	0007.7256.1CBB
41	00:19:8F:2F:D1:E5	0019-8F2F-D1E5	0019.8F2F.D1E5
42	00:07:72:87:51:11	0007-7287-5111	0007.7287.5111
43	00:07:72:89:53:3D	0007-7289-533D	0007.7289.533D
44	00:07:72:7B:3F:35	0007-727B-3F35	0007.727B.3F35
45	00:07:72:6F:14:2B	0007-726F-142B	0007.726F.142B
46	00:07:72:7B:3F:A9	0007-727B-3FA9	0007.727B.3FA9
47	00:19:8F:5F:EB:98	0019-8F5F-EB98	0019.8F5F.EB98
48	00:19:8F:2F:F4:85	0019-8F2F-F485	0019.8F2F.F485
49	08:9C:86:E5:A1:38	089C-86E5-A138	089C.86E5.A138
50	08:9C:86:E5:A1:30	089C-86E5-A130	089C.86E5.A130
Sheet1

Cell Formulas
Range	Formula
B2:B50	B2	=REPLACE(REPLACE(SUBSTITUTE(SUBSTITUTE(A2,"-",""),":",""),5,0,"-"),10,0,"-")
C2:C50	C2	=REPLACE(REPLACE(SUBSTITUTE(SUBSTITUTE(A2,"-",""),":",""),5,0,"."),10,0,".")

 

[Georgiboy]

Ever so sightly shorter:

Book1
	A	B	C
1	Input	Output 1	Output 2
2	5c-4c-a9-17-21-a1	5c4c-a917-21a1	5c4c.a917.21a1
3	5c-4c-a9-16-b5-6d	5c4c-a916-b56d	5c4c.a916.b56d
4	38-4c-4f-a6-6f-4b	384c-4fa6-6f4b	384c.4fa6.6f4b
5	5c-4c-a9-17-2c-e0	5c4c-a917-2ce0	5c4c.a917.2ce0
6	70-7b-e8-52-c5-6e	707b-e852-c56e	707b.e852.c56e
7	70-7b-e8-5f-64-47	707b-e85f-6447	707b.e85f.6447
8	70-7b-e8-5f-66-85	707b-e85f-6685	707b.e85f.6685
9	38-4c-4f-65-7c-7f	384c-4f65-7c7f	384c.4f65.7c7f
10	c8-8d-83-13-63-34	c88d-8313-6334	c88d.8313.6334
11	70-7b-e8-5f-5d-db	707b-e85f-5ddb	707b.e85f.5ddb
12	5c-4c-a9-17-30-8e	5c4c-a917-308e	5c4c.a917.308e
13	00:19:8F:63:24:6C	0019-8F63-246C	0019.8F63.246C
14	E0:30:05:E2:F8:C5	E030-05E2-F8C5	E030.05E2.F8C5
15	00:19:8F:60:63:90	0019-8F60-6390	0019.8F60.6390
16	00:19:8F:62:0E:33	0019-8F62-0E33	0019.8F62.0E33
17	00:19:8F:80:7B:06	0019-8F80-7B06	0019.8F80.7B06
18	00:19:8F:80:90:1F	0019-8F80-901F	0019.8F80.901F
19	00:19:8F:80:97:E6	0019-8F80-97E6	0019.8F80.97E6
20	00:19:8F:80:70:D7	0019-8F80-70D7	0019.8F80.70D7
21	00:19:8F:80:90:2A	0019-8F80-902A	0019.8F80.902A
22	00:19:8F:80:97:6D	0019-8F80-976D	0019.8F80.976D
23	00:19:8F:80:80:65	0019-8F80-8065	0019.8F80.8065
24	00:19:8F:80:5D:13	0019-8F80-5D13	0019.8F80.5D13
25	00-18-82-B8-09-72	0018-82B8-0972	0018.82B8.0972
26	00-18-82-B8-1C-CE	0018-82B8-1CCE	0018.82B8.1CCE
27	00-18-82-B8-1C-D0	0018-82B8-1CD0	0018.82B8.1CD0
28	00-18-82-B8-09-7E	0018-82B8-097E	0018.82B8.097E
29	00-18-82-97-A7-86	0018-8297-A786	0018.8297.A786
30	00-25-9E-56-36-3F	0025-9E56-363F	0025.9E56.363F
31	08-19-A6-F1-E8-A2	0819-A6F1-E8A2	0819.A6F1.E8A2
32	00-25-9E-56-35-91	0025-9E56-3591	0025.9E56.3591
33	00-25-9E-0C-67-50	0025-9E0C-6750	0025.9E0C.6750
34	00-25-9E-93-81-C3	0025-9E93-81C3	0025.9E93.81C3
35	00-25-9E-92-DF-EF	0025-9E92-DFEF	0025.9E92.DFEF
36	00-25-9E-22-3C-93	0025-9E22-3C93	0025.9E22.3C93
37	00:19:8F:60:0C:4B	0019-8F60-0C4B	0019.8F60.0C4B
38	00:07:72:82:C0:3F	0007-7282-C03F	0007.7282.C03F
39	00:07:72:7D:28:53	0007-727D-2853	0007.727D.2853
40	00:07:72:56:1C:BB	0007-7256-1CBB	0007.7256.1CBB
41	00:19:8F:2F:D1:E5	0019-8F2F-D1E5	0019.8F2F.D1E5
42	00:07:72:87:51:11	0007-7287-5111	0007.7287.5111
43	00:07:72:89:53:3D	0007-7289-533D	0007.7289.533D
44	00:07:72:7B:3F:35	0007-727B-3F35	0007.727B.3F35
45	00:07:72:6F:14:2B	0007-726F-142B	0007.726F.142B
46	00:07:72:7B:3F:A9	0007-727B-3FA9	0007.727B.3FA9
47	00:19:8F:5F:EB:98	0019-8F5F-EB98	0019.8F5F.EB98
48	00:19:8F:2F:F4:85	0019-8F2F-F485	0019.8F2F.F485
49	08:9C:86:E5:A1:38	089C-86E5-A138	089C.86E5.A138
50	08:9C:86:E5:A1:30	089C-86E5-A130	089C.86E5.A130
Sheet1

Cell Formulas
Range	Formula
B2:B50	B2	=REPLACE(REPLACE(TEXTJOIN("",,TEXTSPLIT(A2,{"-",":"})),5,,"-"),10,,"-")
C2:C50	C2	=REPLACE(REPLACE(TEXTJOIN("",,TEXTSPLIT(A2,{"-",":"})),5,,"."),10,,".")