Function to extract last name with VBA

[Neeraj Chaudhary]

Sorry! Removed

[RudiS]

Try this:

Please Login or Register  to view this content.

[Neeraj Chaudhary]

Thanks Rudy!

But not solving my purpose.

Function lastName(FullName As String) As String
lastName = Left(FullName, WorksheetFunction.Find(",", FullName) - 1)
End Function