How do I identify the character é in a value and replace it with e?
I am using Excel to hold data for a MailMerge. Each column represents a piece of data that is either used in the MailMerge or uploaded onto a CRM.
In the case of French names there are often characters like é in a last name, for example: Bélanger. It would be correct to address someone by "Ms. Bélanger" but "jenny.bélanger@url.com" is not allowed.
For the sake of this question assume that columns A, B, C are First, Last, Email respectively.
A and B are entered in manually. Column C contains an email that is generated using concatenate and following the company email naming convention.For example if email naming convention is "firstname.lastname@example.org" the formula is =concatenate(lower(a1),"."lower(b1),"@url.com")
Is it possible to enter a French name correctly as a value in the name column but automatically replace an é with e for the email value?