I have another question.
In Col A, day is changing from A463.
What is the best way to tell excel that it is a new day?
This is an issue because if I try to plot something vs. time, excel doesn't automatically add a next day rather starts plotting from beginning.

Thanks.