formatting MAC Addresses

C

cygnussphere

I get mac addresses that are like this.

001B24E0382C 001B24E0382D

I need to format or convert them via formula to this.

00:1B:24:E0:38:2C|00:1B:24:E0:38:2D

Any help would be greatly appreciated.

Thanks!
 
R

Roger Govier

Hi

One way
=MID(A1,1,2)&":"&MID(A1,3,2)&":"&MID(A1,5,2)&":"&MID(A1,7,2)
&":"&MID(A1,9,2)&":"&MID(A1,11,2)&"|"&MID(A1,14,2)&":"&
MID(A1,16,2)&":"&MID(A1,18,2)&":"&MID(A1,20,2)&":"
&MID(A1,22,2)&":"&MID(A1,24,2)
 
C

cygnussphere

This works for me. Thanks!

Roger Govier said:
Hi

One way
=MID(A1,1,2)&":"&MID(A1,3,2)&":"&MID(A1,5,2)&":"&MID(A1,7,2)
&":"&MID(A1,9,2)&":"&MID(A1,11,2)&"|"&MID(A1,14,2)&":"&
MID(A1,16,2)&":"&MID(A1,18,2)&":"&MID(A1,20,2)&":"
&MID(A1,22,2)&":"&MID(A1,24,2)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help for Excel Formula 0
Cell Formatting 1
Countif Problem 4
USB disk silent read errors 2
PR_RTF_COMPRESSED open failed 0
The order of numbers mixed with letters 1
time calculation, 24:00 - 16:00 = 8 4
time calculation, 24:00 - 16:00 = 8 3

Top