Using vba -how do I remove characters from right of space on all cells in specific columns

Sorry if this is a stupid question, but I am new to vba and I am trying to remove characters from the right of a space

an example of the text in the cell is - 5/08/2015 at 12:22 PM

I want to reduce it to 5/08/2015 (formatted as d/mm/yyyy)

Please Login or Register  to view this content.

this removes the time from the end of the one cell, but I am struggling to get it to work on all cells within 3 columns ("E:G")

Can anyone assist please?

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Hello GBegnall,

Try it as follows:-

Please Login or Register  to view this content.

If your data starts in E3, then change E1 in the code to E3.

I hope that this helps.

Cheerio,
vcoolio.

Please Login or Register  to view this content.

This also works but not all cells format as dates

When I use the column filter only some of the cell values list within the relevant year.

Attachment 735840

even though the entire column is formatted as date d/mm/yyyy

Your attachments are all invalid, so can not open.

my guess,

Please Login or Register  to view this content.