Help require to create a signature

Hi friends,
There is a list of teachers on ‘Information’ sheet.
I want a signature on ‘Card’ sheet on the following conditions.
If the name of teacher has a title/prefix ‘Mr.’ then there will be a signature starting with ‘Sir’
Else
The signature will start with ‘Madam’

I have attached a workbook for your kind perusal.

Thanking you,

=IF(LEFT(A1,3)="Mr.","Sir","Madam")

This will also turn any "Miss" into "Madam"
Are you sure that's what you want?

Hi,

You can create the function for the same..

Function MySign(Name As String)

    If InStr(1, Name, "Mr.", vbTextCompare) <> 0 Then
        MySign = "Sir: " & Name
    ElseIf InStr(1, Name, "Mrs.", vbTextCompare) <> 0 Or InStr(1, Name, "Ms.", vbTextCompare) <> 0 Then
        MySign = "Madam: " & Name
    Else
        MySign = "No Titles"
    End If
    
End Function

Here is your attachment..Sign.xlsm


If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.

Hi Special-K,
Perfect! It's working absolutely fine as per my requirement. Thank you,

Hi LokeshKumar,
Thank you for a function. It's a nice approach.

Thank you to both of you.

If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.