Updating a field to create a html link based on data in another field

[divster27]

I upload products to my website using a number of excel files from suppliers.
So far, i've created a good data uploader, but i lack the skills required for the final bit, which is to create a field that will show what the final html link for the product will be

an example

Joe Henderson – Inner Urge – Netdiscs

The product name is Joe Henderson - Inner Urge

So i want to create a field that turns that bit of text into joe-henderson-inner-urge - i will be using this field as part of an automated mail shot

So - ultimately, remove all the spaces, and replace with "-"

It won't always be 4 words, it could be as many as....

CRO-MAGS – HARD TIMES IN THE AGE OF QUARREL VOL 1 (WHITE VINYL) – Netdiscs

Any suggestions appreciated!

Cheers
David
Netdiscs

 

[Candyman8019]

You could try something like this assuming your value is in A1:
=substitute(A1," ","-")

 

[divster27]

That's great - thanks!

wasn't sure quite how to do it as the product name already had a "'-" in it, but it is based on two other fields (artist and title)

so..........

="https://www.netdiscs.net/product/"&(SUBSTITUTE(B2," ","-")&"-"&SUBSTITUTE(C2," ", "-"))&"/"

gives me

Joe Henderson - Inner Urge - Netdiscs

www.netdiscs.net

where b2 = "joe Henderson"
and c2 = "inner urge"

Works well, thanks !

David

 

[Candyman8019]

Happy to help.