Hi all,

In a cell value (loaded from a .cap file) i have the date, which i need to use for ensuring that (when i work out how to do it), my copied range goes into the right sheet.

So, i have the date in 1 cell in this format:
Wed 17 Nov 2004 05:34P

Is there any VBA that could almost take apart the value, and extract the necessary data?

I was thinking something along the lines of removing the first 4 characters, keeping the next 11 and removing anything after that.

That would then leave me with 17 Nov 2004, which i would then use for the lookup fun thats ahead of me.

Any ideas, or advice?
Thank you so much