Replace characters in mergefield

[tommatwalker]

Hi all,



I'm sure this has been asked before but I can't find it on this fine forum!

I am new to using mergefields and I am hoping to do some manipulation on the data within one. I have a field that contains employee names i.e. "Firstname Lastname" and I know that the standard form for company email addresses is "firstname.lastname@companyname.co.uk".

My question is is there a way within mergefield if formulas to automatically format the name field to an email field i.e. replace the space with a "." and add the email url at the end?

Thanks in advance.

Regards

Tom