change values to lower case & paste in a different column

Hi All,
the values in A1 need to be converted to lower case and a "-" added between the words
Eg: feilun-ft009-boat-spare-parts-tail-propeller-ft009-12 & paste it in column "N2"
the same data (add .html) Eg: feilun-ft009-boat-spare-parts-tail-propeller-ft009-12.html to be pasted in "O2)
see attachment

Thanks

Column N formula

Please Login or Register  to view this content.

Column O formula

Please Login or Register  to view this content.

Hi ThirtyTwo,

it worked but is there a way to do it with a macro

Thanks
Robin

Bump it Up