If you know the string will be exactly 12 bytes long then you
can use the worksheet formula :

=MID(A1,1,2)&":"&MID(A1,3,2)&":"&MID(A1,5,2)&":"&M ID(A1,7,2)&":"&MID(A1,9,2)&":"&MID(A1,11,2)


NickHK wrote:
There is no command in Excel, that's why you need to write your own.

Make that code a Public Function in a module, then you can call it from the
worksheet with:
e.g. in cell A1, "=InsertCharsInString("0014f8c49563", ":", 2)"

Google for "Excel User defined function", you get a lot of help.

NickHK

"xtrmhyper" wrote
in message ...

i dont any idea for that command

any formula in excel?


tnx in advace:)


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