excel vba problem

[hanks]

Hello,

I have a list of names in excel with including names and both names an
surnames in some columns,
can you help me to extract only surnames into the different cell?


A1=Adams
A2=B.Bryan
A3=M.Bridge
A4=Jane
I want to have B1=" ",B2="Bryan",B3="Bridge",B4=" "


Thanks so much in advance

 

[jim]

please try this one
=IF(ISERROR(FIND(".",A1)),"",RIGHT(A1,LEN(A1)-FIND(".",A1)))