Thread: How to format a cell to reflect a NIC's MAC Address ? (put in dash
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
  
Posts: 1,047
Default How to format a cell to reflect a NIC's MAC Address ? (put in dash
what about to use =substitute(a2,"-","")

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"jfen" escreveu:

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 With QuoteReply With Quote