formula to convert uppercase to lowercase and spaces to hyphens

[Rogelio Emmanuel Valtierra Ayala]

formula to convert uppercase to lowercase and spaces to hyphens

Example

Binary systems         binary-systems  
Digital TV                 digital-tv
High system             high-system 
WIRELESS                 wireless

[#2]

=LOWER(SUBSTITUTE(A1," ","-"))

[#3]

you could upload a document with an example of the formula is that I do not get it correctly

[#4]

---

@Sergei Baklan wrote:

=LOWER(SUBSTITUTE(A1," ","-"))

---

puedes subir un documento con un ejemplo de la fórmula es que no lo entiendo correctamente

[#5 · Accepted solution]

Here it is