一种选择:
公式B1
:
=LET(x,{"All De ","All Des ","Che Du ","Esp ","Imp De La ","R De La ","R De L'","R De ","R "},y,PROPER(SUBSTITUTE(A1,x,,1))&" ("&{"Allée de","Allée des","Chemin du","Esplanade","Impasse de la","Rue de la","Rue de l'","Rue de","Rue"}&")",XLOOKUP(1,COUNTIF(A1,x&"*"),y,"No Match Found"))