How to use LOWER and SUBSTITUTE in the same cell?

[PowerPal]

Hi all,

I'm trying to make this: "Sly Fox" into this "sly-fox" using lower and substitute in one cell however I can only get one to work.

Can someone help me with this?


Thanks

 

[jbeaucaire]

Like so:

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

 

[PowerPal]

Thanks, that works perfectly.