Delete the first 4 characters in a text in all cells in a column

Copper Contributor

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

1 Reply

@MacSterling If you have access to last released formulas then could try-

=SORTBY(A2:A4,TEXTAFTER(A2:A4,"-"),1)

Harun24HR_0-1662606707236.png