Sep 07 2022 07:59 PM
I have a long list of offices with a 3 digit code followed by a "-" and then the office name. I want to sort the column in alphabetical order by the office names.
If I can sort by the office name while ignoring the office number, fine. Otherwise, can I remove the first 4 characters in the cell entry
Sep 07 2022 08:11 PM
@MacSterling If you have access to last released formulas then could try-
=SORTBY(A2:A4,TEXTAFTER(A2:A4,"-"),1)