Hi, i need to replace the notes of a long text with the next note.
Example “Nto Re Re Mi” change to “Re Mi Mi Fa”. i try
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
SUBSTITUTE(SUBSTITUTE(([transporto]); “Nto”;“Re”); “Re”;“Mi”);
“Mi”;“Fa”)...