Posted to microsoft.public.excel.programming

xtrmhyper[_8_] xtrmhyper[_8_] is offline

external usenet poster

Posts: 1

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
format colon	Pammy	Excel Discussion (Misc queries)	2	March 24th 09 08:48 PM
how to change colon to semi-colon in CP/List Seprator	Khoshravan	Excel Discussion (Misc queries)	3	February 4th 09 07:41 PM
Center on colon	WJason	Excel Discussion (Misc queries)	3	August 20th 07 09:54 PM
Add colon to times	meridklt	New Users to Excel	4	May 11th 07 09:36 PM
Colon in code?	davegb	Excel Programming	4	January 13th 06 04:09 PM

All times are GMT +1. The time now is 09:32 PM.

About Us

"It's about Microsoft Excel"