Forum Discussion

Copper Contributor

Aug 06, 2018

Solved

formula to convert uppercase to lowercase and spaces to hyphens

formula to convert uppercase to lowercase and spaces to hyphens Example Binary systems binary-systems Digital TV digital-tv High system high-system WIREL...

excel

Excel Online

Formulas and Functions

Macros and VBA

SergeiBaklan
Aug 06, 2018
Here it is
lower text.xlsx10 KB

SergeiBaklan

Diamond Contributor

Aug 06, 2018

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

Rogelio Emmanuel Valtierra Ayala

Copper Contributor

Aug 06, 2018

SergeiBaklan wrote:
=LOWER(SUBSTITUTE(A1," ","-"))


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

Rogelio Emmanuel Valtierra Ayala
Copper Contributor
Aug 06, 2018
you could upload a document with an example of the formula is that I do not get it correctly
- SergeiBaklan
  Diamond Contributor
  Aug 06, 2018
  Here it is
  lower text.xlsx10 KB