Bonjour valmax, CB60,
C'est a cause des retours chariots que tu as dans tes colonnes, voici un code a mettre dans ta feuille.
Private Sub Worksheet_selectionChange(ByVal Target As Range)
Dim x As String
If Target.Count > 1 Then Exit Sub
x = Replace(Trim(Target), Chr(13), " ")
If Trim(UCase(Trim(x))) = "HOMME" Then Target = "M"
If Trim(UCase(Trim(x))) = "FEMME" Then Target = "Mme"
End Sub