Change part of date format

Hello!

I am a beginner when it comes to creating formulas in Excel.

I have a column which consists of date and time in the same cell.

Original data:
2015-07-25 00:00:00 UTC

What I am trying to do is come up with a formula to change the date format to MM/DD/YYYY and not use the time stamp at all.

New format after formula:
7/25/2015

Any insights will be much appreciated!

Thank you so much in advance!

Carol

is it seen as a date in the cell , if so , then you should be able to change format to just the date
or if text , you can use a formula in another column BUT not in the same column without VBA
=Left(cell, 10)
should extract just the date
=DATEVALUE(LEFT(A1,10))
then format the cell to how you want to display the date

then you could copy and paste value back to the original column