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

Occasional Visitor

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-