MAC address format in Excel

J

JayCee

Hello,

I've imported several hundred lines of data into an Excel spreadsheet. One
of the columns contains the MAC addresses for some equipment. I want to take
the existing data, which is just 12 alphanumeric characters and put it in the
common format for MAC addresses (ex. 00:11:AA:BB:1A:1B).

Thanks,

Jeff
 
V

Val

how about something like:

=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))

Where cell A1 is your 12 char MAC

Val

Hello,

I've imported several hundred lines of data into an Excel spreadsheet. One
of the columns contains the MAC addresses for some equipment. I want to
take
the existing data, which is just 12 alphanumeric characters and put it in
the
common format for MAC addresses (ex. 00:11:AA:BB:1A:1B).

Thanks,

Jeff
 
Top