How to add ":" in cell

[nantu]

Dear All,

Help me regarding how to add ":" in cell where cell contains [TABLE="width: 90"]
<tbody>[TR]
[TD="width: 90"]2c27d7efa4a1. Length of the cell is 12.
Outcome will be 2c:27:d7:ef:a4:a1

Help me.
Thanks in advance[/TD]
[/TR]
</tbody>[/TABLE]

 

[SyedUsman]

Plz Try this

=CONCATENATE(MID(A1,1,2),":",MID(A1,3,2),":",MID(A1,5,2),":",MID(A1,7,2),":",MID(A1,9,2),":",MID(A1,11,2))

 

[nantu]

thank you very much.. It is working.

 

[AlKey]

Or this

[B]=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,11,,":"),9,,":"),7,,":"),5,,":"),3,,":")[/B]

Book1
	A	B
1	2c27d7efa4a1	2c:27:d7:ef:a4:a1
Sheet1