Macro for deleting part of a cell's content?

[towersjd]

Hi all, I'm brand new here so apologies if I am posing this question in the wrong place.

I am moving information from an exported automated report to a new, separate worksheet. The information I need help with is regarding the date column. The automated report generates a date AND a time.

ex: "8/30/2016 1:53:00 PM"

I need it to solely show the date and somehow remove the time stamp.

ex: "8/30/2016"

I tried playing around with different formats but much to my dismay none of them worked. Is there any other option for accomplishing this besides manually deleting the excess text? If not, does anyone have a macro that would do this for me? I have over 1000 cells of data and would prefer not to spend my time manually deleting it.

Any help or advice would be appreciated!

Thanks!

 

[Sektor]

Doesn't DATE cell format fit?

 

[towersjd]

No it doesn't. This is what I expected to do, but I'm thinking that maybe the millisecond part throws it off? Or maybe I'm just completely missing something.

 

[Sektor]

Try to use this formula: =LEFT(A1,FIND(" ",A1))

 

[towersjd]

Oh, I just have to click in each cell. Then it formats. I have a macro for that. Whoops. Sorry for the confusion