Is there a function that identifies proper names

[hectc7]

Here is the scenario, We have an excel list of terms but we want to isolate those terms that are proper names of schools.

In real life we want to isolate the proper name term from the following list

cat
dog
Murry's school
church

Is there such a function??

Thanks!

 

[Joe4]

So, you are basically looking for any entry with a capital letter in it, right?
If so, you use Conditional Formatting to bold or highlight those entries.
Let's say that those values are in column A. Then select column A, and enter this Conditional Formatting Formula:

=EXACT(A1,LOWER(A1))=FALSE

and choose your bold or highlight formatting.

 

[James006]

Hello,

May be a simple UDF ...

Function IsFirstLetterCaps(str As String) As Boolean
' Example in cell B1 = IsFirstLetterCaps(A1)
  IsFirstLetterCaps = (Left(Trim(str), 1) = UCase(Left(Trim(str), 1)))
End Function

Hope this will help