How to delete the row that contain unwanted alphabet and the time (example: 8:35AM), stay only the numeric. There are thousand of data, so I can't specify which row is it.
Go to Solution
For Each Row(
If( Right(:Time,2) == "AM",
:Time = substr(:Time, 1, Length(:Time) -2
Is this what you are trying to do?