muskrat1977 muskrat1977 is offline

Junior Member

Posts: 1

Inserting a colon into text

Hello

I have imported text that has the following format:
20 May 2014 1715

I need it to be in the following format:
20 May 2014 17:15

Can you help?

Reply With Quote

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
how to change colon to semi-colon in CP/List Seprator	Khoshravan	Excel Discussion (Misc queries)	3	February 4th 09 07:41 PM
Inserting colon as text	iashorty	Excel Programming	4	June 24th 08 03:31 PM
inserting colon into a value at a specific interval	[email protected]	Excel Programming	4	August 1st 07 07:54 PM
inserting colon	xtrmhyper[_8_]	Excel Programming	8	July 1st 06 07:28 PM
Insert colon in text in cell	Phoenix	Excel Discussion (Misc queries)	4	February 3rd 06 09:16 AM

All times are GMT +1. The time now is 07:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us