Skip to content

Instantly share code, notes, and snippets.

@mcantillana

mcantillana/funcion_excel_url_alias

Last active January 1, 2016 20:39
Show Gist options
  • Save mcantillana/8198306 to your computer and use it in GitHub Desktop.
Save mcantillana/8198306 to your computer and use it in GitHub Desktop.
Download ZIP
Función para limpiar cadena y construir URL amigable para opencart
Raw
funcion_excel_url_alias
=SUSTITUIR(SUSTITUIR(SUSTITUIR(SUSTITUIR(SUSTITUIR(SUSTITUIR(SUSTITUIR(SUSTITUIR(SUSTITUIR(SUSTITUIR(SUSTITUIR(D2;"á";"a");"é";"e");"í";"i");"ó";"o");"ú";"u");"ñ";"n");"/";"-");" ";"-");"(";"-");")";"-");".";"")
=ESPACIOS(MINUSC(C2))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment