Forum Discussion

ElJarrod's avatar
ElJarrod
Copper Contributor
Dec 05, 2019

How to sort column (of character strings starting with MMDDYY) by date?

Hello everyone, I'm sure there's an efficient way to do this but I'm stumped, so I turn to the experts.   I have a spreadsheet where one of the columns is filled with character strings that be...
excel
ElJarrod's avatar
ElJarrod
Copper Contributor
Dec 05, 2019

Thank you for the suggestions, they will likely come in handy another time.

I kept playing with the wildcards and I'm not sure why what I initially tried didn't work but eventually I did searches for:
*14-

*15-

*16-

*17-

*18-

 

And replaced them all with:

001-

 

My ultimate goal was a little more nuanced than I described. What I needed to do was isolate only the 2019 records. So I sorted the column A-Z, which moved all of those non-2019 records to the top. Then I just shift-selected all of them and deleted them.

 

Thanks again.

  • crazyshoots's avatar
    crazyshoots
    Brass Contributor
    Dec 05, 2019
    @euarrod if the comments were of help in any way, please like the post.. am asking because while most contributors are contributing out of Goodwill; having the likes is a way of appreciating the time and effort invested and motivates them more to help out in future 🙂
    • ElJarrod's avatar
      ElJarrod
      Copper Contributor
      Dec 06, 2019
      Absolutely!