Forum Discussion

MacSterling's avatar
MacSterling
Copper Contributor
Sep 08, 2022

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

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

Resources