excel vba problem

  • Thread starter Thread starter hanks
  • Start date Start date
H

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
 
please try this one
=IF(ISERROR(FIND(".",A1)),"",RIGHT(A1,LEN(A1)-FIND(".",A1)))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Very strange behaviour of VLOOKUP in Excel 2010 4
Data Validation and drop-down list using IF, AND and what else? 8
find oldest date with a condition 4
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Lookup 14
simple math question 3
Copy Data from One sheet to Different Sheets 1
Newbie question on Lookup error 6

Back
Top