02-04-2016 02:41 PM
There is a column Customer name with first and last names together. not all the values have both first and/or last names. Want to know how many of them truly have both first and last names. They are separated by spaces.
02-04-2016 07:27 PM
You can count the words in a name but you can't accurately check if they have both first and last name.
For example is Bruce Roger two first names or a first name and a last name? Either of these names could be a first name or a last name.
Another: Van Hurst - is this a first name and a last name or a two word last name?