Cell Formated for MAC address

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hi,

Is there a way to format a cell to display twelve alphanumeric characters to
look like a MAC address?

For example, if the cell contents are: 0003FF411153
I want it to display like this: 00-03-FF-41-11-53

If a MAC address were all numeric's, the following would work::
##"-"##"-"##"-"##"-"##"-"##
But because MAC addresses have characters A-F, this won't work for me.

I tired using: @-@-@-@-@-@ but that didn't work either.
Any thoughts?

Thanks!
 
Maybe you can use a helper column and a formula to format it pretty. Format
column A (say) as Text and then:

=left(a1,2)&"-"&mid(a1,3,2)&"-"&mid(a1,5,2)&"-"& .....
 
Back
Top