Posted to microsoft.public.excel.programming

external usenet poster

Posts: 386

Delete ' from date

Hi,

i have 10523 lines with dates in col D, with dates written as '27/10:09 etc.
What code could i use to find all the ' and delete them?

Thanks

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
Delete Date Macro	Workbook	Excel Programming	1	February 20th 09 07:53 AM
Delete Rows If Date Less Than Date Value	Joe K.	Excel Programming	1	October 4th 07 10:50 PM
how do I delete a row automatically after each date	delete automatically	Excel Discussion (Misc queries)	11	December 20th 06 08:40 PM
Delete row if no date exist	THE_RAMONES	Excel Programming	7	March 29th 06 03:25 PM
Macro want delete the date row?	Shetty	Excel Programming	5	March 3rd 04 02:08 PM

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

About Us

"It's about Microsoft Excel"