|It NEARLY worked!|
My Excel is in Spanish, so I had to write "SUSTITUIR" instead of "SUBSTITUTE".
Maybe for the same reason, I have to use semicolons instead of commas.
The cell I want to modify is C185, whose text is:
...les archéologues|et d'autres autorités.
In cell D185, I wrote:
And I got:
...les archéologues#et d'autres autorités.
But if I write:
(In case you don't know, "NOMBRE" is Spanish for "NAME").
I thought maybe I should use the Spanish version of CHAR(13), does that make sense?
Or CHAR(13) should work for all languages?
Thanks again to both!