Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 61

extract date from text

I have the following text string in cell A1. Flight Schedule - Friday 28th
November 2008.

How can I extract the date from the text string and paste it in cell A2.
Thanks

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
extract date from string	kdp145	Excel Worksheet Functions	3	March 3rd 06 02:54 PM
Extract Date	christmaslog	Excel Worksheet Functions	1	February 19th 06 10:28 AM
extract date from the most current date	Cali00	Excel Discussion (Misc queries)	1	April 13th 05 02:05 PM
How do I extract a date as text not the 1900 reference number	Adam	Excel Discussion (Misc queries)	3	March 23rd 05 05:04 PM
EXTRACT TEXT FROM A DATE	Ronbo	Excel Worksheet Functions	5	February 1st 05 07:39 AM

All times are GMT +1. The time now is 04:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us