How to format a cell to reflect a NIC's MAC Address ? (put in dash

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jfen - 17 Aug 2006 20:35 GMT

I have a long column of NIC's MAC Addresses WITHOUT the dashes between every
2 characters. Need to know how to create an excel custom format to make them
all have the dashes without manually putting in dashes.

Reply to this Message

Marcelo - 17 Aug 2006 20:45 GMT

what about to use =substitute(a2,"-","")

hth

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

> I have a long column of NIC's MAC Addresses WITHOUT the dashes between every
> 2 characters. Need to know how to create an excel custom format to make them
> all have the dashes without manually putting in dashes.

Reply to this Message

Dave Peterson - 17 Aug 2006 21:35 GMT

You could insert a helper column and make it look like you want:

=if(a1="","",mid(a1,1,2)&"-"&mid(a1,3,2)&"-"&mid(a1,5,2)&"-"&mid(a1,7,2)& ...

(I got tired! Just continue until you're out of numbers! <vbg>.)

Signature

Dave Peterson

Reply to this Message