Thread: inserting colon
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default inserting colon

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