If you don't want to use the "replace" function to delete, and the word "Ningbo Ninghai" is in the first four words of a column, you can use the following method.

Set the original data in column A and enter it into b2:

= if (left (a2,4) = "Ningbo Ninghai", right(a2, len(a2)-4), a2)

Drop-down Fill-> Copy b list cells-> Right-click cell a2-& gt；; Select Paste Special-> Check the "value"->; Click ok-> Delete column b data.