新聞財經娛樂♬資訊 News Economy

Hi,
Add - between words and remove spaces
I need help with a formula that can add a - hyphen where ever a space is available.

This is a line in cell in column A
Should be
This-is-a-line-in-cell-in-column-A

If we have a space at the end should not add a space example or start

-This-is-a-line-in-cell-in-column-A-

thanks

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


that should work for your case