vba ...if then on base of "cell contains xxx" instead of cell = "xxx"

Dears would like to modify below vba macro … into.... if cell contains certain data instead of specific text
fi below VBA
if Range ("a2").Value = "a" Then
Range ("b2").Value = "1"
ElseIf Range ("a2).Value = "b" Then
Range ("b2").Value = "2"
ElseIf Range ("a2).Value = "c" Then
Range ("b2").Value = "2"
End If
End Sub

Would like to have outcome 1 if data in cell a2 contains an "a" ….. I tried "*a*" but it is not going.
Can someone help me please
Thanks
Danny

Hello. Try this:

Please Login or Register  to view this content.