MS Excel experts - Please advise
If b1 is apple, c1 is 2013 macbook pro, d1 is mx123
In a1, I need a formula that will write (apple-2013-macbook-pro-mx123)
Any advise?
Right now I can only create a formula that helps create dashes in just one cell.
Example, if cell c1 is "apple 2013 macbook pro mx123"
This formula: =LOWER( SUBSTITUTE( A1, " ", "-"))
will create apple-2013-macbook-pro-mx123
-
Natino -
Thanks
{{ DiscussionBoard.errors[8492526].message }} -
-
NatesMarketing -
[ 1 ] Thanks - 1 reply
{{ DiscussionBoard.errors[8492582].message }}-
yehabits -
[ 1 ] Thanks - 1 reply
{{ DiscussionBoard.errors[8493052].message }}-
Steven Roberts -
Thanks
SignatureFREE TOOLS AND DOWNLOADS for Low Content and KDP Publishers https://istack.link{{ DiscussionBoard.errors[8493222].message }} -
-
-