Uppercase next Lowercase

[Manolocs]

Hello, I have to search a long list only column A if there is any word with an Uppercase letter following by the second in Lowercase. Difficult to explain....
Column.........................Column
A.......................................B
Doris Angel.........................""
Ruper michael................Check This
Barack obama................Check This
Ryan Thomas......................""

I know how to capitalize the first letter of the words, but some of them can not be capitalized so I need to check if need or not. Thanks in advance.

 

[Manolocs]

@Fishboy open an error message SUBSCRIPT OUT OF RANGE.

 

[Fishboy]

@Fishboy open an error message SUBSCRIPT OUT OF RANGE.

Hmm, which line highlights as the issue when you press debug on the error?

 

[FormR]

Perhaps you can start a thread to find the 50th using Excel functions only?

Haha, maybe I should

 

[Fishboy]

@Fishboy open an error message SUBSCRIPT OUT OF RANGE.

I cannot recreate the issue. Here is the test document I wrote the code in and it seems to be working fine.

 

[Steve_R]

Public Function BinComp(Val1, Val2)

BinComp = StrComp(Val1, Val2, 0) '0=Binary Compare

End Function

=IF(BinComp(B2,PROPER(B2)),"Check This","")

 

[Manolocs]

@Fishboy Hi great idea so I could copy my data to your worksheet but I am getting the same error in yours, so I think the problem (I did not mention sorry) that are some cells has more than 5 words other only one, what I need is only check the second word if is lowercase and show the message. Sorry for the delay but I had to ask a PC to try, I was using Mac .

 

[Fishboy]

@Fishboy Hi great idea so I could copy my data to your worksheet but I am getting the same error in yours, so I think the problem (I did not mention sorry) that are some cells has more than 5 words other only one, what I need is only check the second word if is lowercase and show the message. Sorry for the delay but I had to ask a PC to try, I was using Mac .

Ahh, my code unfortunately assumes that there is only one space in each cell and will probably misbehave when cells contain more.

Now that I know this additional parameter, I can at least try to recreate the issue at my end and see if I can figure out a solution.

[EDIT - Having tested with multiple words / spaces, I still cannot recreate the issue and these are the results of my latest test]

Excel 2010
	A	B
1	Adam jones	Check This
2	John smith	Check This
3	Joe Bloggs
4	John Doe
5	Testy mctest	Check This
6	CARLS Clark
7	MARY/PETER Dustin
8	TOM/Paul harris	Check This
9	Testy mctesting testerson	Check This
10	Lee Harvey Oswald
11	test test test test test	Check This
12	Test Test blah blah blah
Sheet1

 

[Manolocs]

I got the errors for one word in the cell as well. Really thank you for your time

 

[FormR]

I think the problem (I did not mention sorry) that are some cells has more than 5 words other only one, what I need is only check the second word if is lowercase and show the message.

Which is why it would be a good idea to this..

please post a good representative set of the different possible options and the expected outcome for each

 

[István Hirsch]

Not sure it will cover all eventualities but this may help

=IF(CODE(MID(A1,FIND(" ",A1)+1,1)) > =97,"Check","OK")

It results #Error as there is a space between the "greater than" and the "equal" character.