Posted to microsoft.public.excel.misc

Posts: n/a

removing date data from a cell

I use networkdays for my calculation...The 2 cells that the dates are
pulled from are set like such; From: Monday, May 8,2006 and Through:
Wednesday, May 10, 2006.

How would I go about removing the commas, colons, from, through and day
in VBA?

Thanks,

Hans

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
if data in one cell, then date in adjacent cell	Jane	Excel Worksheet Functions	8	December 22nd 07 03:34 AM
Removing a blank cell between data	Bonnie, OH	New Users to Excel	1	February 27th 06 08:07 PM
Removing data from cell within an excel spreadsheet	Dawn	Excel Discussion (Misc queries)	6	February 21st 06 05:16 PM
Last cell of data in a column	LACA	Excel Discussion (Misc queries)	1	January 17th 06 08:22 PM
Help PLEASE! Not sure what answer is: Match? Index? Other?	baz	Excel Worksheet Functions	7	September 3rd 05 03:47 PM

All times are GMT +1. The time now is 04:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us