format computer mac address

[loomis]

I am scanning into Excel, computer mac addresses from a bar code. The addresses look like 23e643eea2a6 . I would like to have the addresses formatted to look like 23:e6:43:ee:a2:a6. How can this be done?

 

[mole999]

this works visually

=CONCATENATE(LEFT(A1,2),":",MID(A1,3,2),":",MID(A1,5,2),":",MID(A1,7,2),":",MID(A1,9,2),":",RIGHT(A1,2))

 

[dyaron]

=mid(a1,1,2)&":"&mid(a1,3,2)&":"&mid(a1,5,2)&":"&mid(a1,7,2)&":"&mid(a1,9,2)&":"&mid(a1,11,2)

 

[loomis]

it works, thank you both.