Thread: inserting colon
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xtrmhyper[_8_] xtrmhyper[_8_] is offline
external usenet poster
 
Posts: 1
Default inserting colon


this is the data
0014f8c49563

how to insert colon automaticaly in every 2nd character

output is 00:14:f8:c4:95:63


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=556466