Posted to microsoft.public.excel.worksheet.functions

Aom

Posts: n/a

Split the date & time in one cell to be 2 colums.

I want to split the date & time in one cell to be 2 colums; Date and another
colum is Time. i.e. 4/11/2006 14.30
How should I do?

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
Split date and time	Warsteiner	Excel Discussion (Misc queries)	2	December 8th 05 10:10 PM
Split combined date time data	Mark Ada	Excel Discussion (Misc queries)	4	December 1st 04 06:47 PM
Split combined date time data	Mark Ada	Excel Discussion (Misc queries)	1	December 1st 04 05:55 AM
Split combined date time data	Mark Ada	Excel Discussion (Misc queries)	1	December 1st 04 03:52 AM
split combined Time Date cells	Mark Ada	Excel Discussion (Misc queries)	2	December 1st 04 03:06 AM

All times are GMT +1. The time now is 07:35 PM.

About Us

"It's about Microsoft Excel"