Thread: How to format a cell to reflect a NIC's MAC Address ? (put in dash
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How to format a cell to reflect a NIC's MAC Address ? (put in dash
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.)

jfen wrote:

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.

--

Dave Peterson
Reply With QuoteReply With Quote