0
I have series of data that are in format of 2018-02-11/20:32:19
. And, I can't work out with formula because of "/" present without any space between date. That "/" some time creates barrier to apply. I don't need options like Filter -"Ctrl+Alt+l" and Sort option under Data tab. I want to know if we can do it like after pasting such data "2018-02-11/20:32:19" in sheet 1 it automatically gets sort or in sheet 2. As we can enter formula in sheet 2 to work upon that.
And also, it has 2 blank rows in between then again such series of different data is present.
Kindly help me out of this issue.
Why not consider and Edit/Replace to change the "/" to a " " space? – Solar Mike – 2018-03-17T22:37:04.873
Or split that column into two based on the
/
then re-join using aspace – ivanivan – 2018-03-17T22:46:56.730
2are those cells formatted as text or as date? – jsotola – 2018-03-17T22:54:23.263