Hello,
i have a large list of names, family and surnames together.
I want to extract surnames ( who are always beginning with capital letter) into new cell.
Somethimes surnames ( 1 or more) are splitted by " - ", ex. Paul-Piet.
It doesn't work,
I' am working with dutch version 2007
Formula is translated correctly but results in error message' a value is not available for this function or formula'
any idea?
thanks
Hi,
I tried this formula on your list. it works. Extracts only upper letter names: even there are two of them
=IF(40-SUM(1-IFERROR(MID(A2;ROW($1:$40);1)=" ";0))<=2;LEFT(A2;FIND(" ";A2;1));LEFT(A2;FIND(" ";A2;FIND(" ";A2;1)+1)))
It is an array formula, dont forget CSE
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.