Regional setting is US.

Do we have to use this formula to remove the time?


=DATEVALUE(LEFT(A2,10))+RIGHT(A2,8)

I am using the same sata/

Thanka