Forum Discussion

NanaNina's avatar
NanaNina
Copper Contributor
May 15, 2023
Solved

Sorting Within a Single Cell

I am trying to sort text information within a single cell so that the latest entry is at the top as opposed to the bottom. The manual effort would be very time consuming (see example). BEFORE ...
excel
  • mtarler's avatar
    mtarler
    May 17, 2023

    NanaNina note that Patrick2788  works unless you cross over the year because it is text sorting those dates.  Here is an option to actually use the date VALUES:

    =LET(in, A1,
   lines, TEXTSPLIT(in,,CHAR(10)),
   sorted, SORTBY(lines,DATEVALUE(TEXTBEFORE(lines,":")),-1),
   TEXTJOIN(CHAR(10),,sorted)
   )

     

NanaNina's avatar
NanaNina
Copper Contributor
May 17, 2023
Good Day. I am receiving a compile error: Expected: end of statement.
Any ideas?

HansVogelaar's avatar
HansVogelaar
MVP
May 17, 2023

NanaNina 

"Expected: End of Statement" suggests that you didn't copy/paste the code correctly.

  • NanaNina's avatar
    NanaNina
    Copper Contributor
    May 17, 2023
    Hmmm, I copied it right from the message. I will play with it when I have time. The solution from Patrick2788 worked for me. 🙂 Thanks for your help though.

Resources