IF Statement for Title Case detection

[surkdidat]

I am using the following formula to detect if the referenced cell has each word capitalised, however, I also need to to take any hyphenated word as one word ie (Horse-box) should be recognised as one word, and not two

=IF(SUBSTITUTE(I2,PROPER(I2),"x")<>"x","Error","Correct")

Horse Box	Correct
Horse box	Error
Horse Box	Correct
Horse-box	Correct
Horsebox	Correct
horse box	Error
horse Box	Error

 

[Fluff]

How about

=IF(EXACT(SUBSTITUTE(I2,"-",""),PROPER(SUBSTITUTE(I2,"-",""))),"Correct","Error")

 

[Muhammad_Usman]

In Mine side it shows Error with hypen cell

Receip.xlsm
	F	G	H	I
2
3		Horse Box	Correct
4		Horse box	Error
5		Horse Box	Correct
6		Horse-box	Error
7		Horsebox	Correct
8		horse box	Error
9		horse Box	Error
10
s_k=discount+items&crid=1LU (2)

Cell Formulas
Range	Formula
H3:H9	H3	=IF(SUBSTITUTE(G3,PROPER(G3),"x")<>"x","Error","Correct")

 

[Fluff]

I think that is what the OP wants to avoid by treating it as a single word, not two.

 

[surkdidat]

I think that is what the OP wants to avoid by treating it as a single word, not two.

Thank you! Apologies been on holiday, and just had a chance to pick back up

 

[Fluff]

You're welcome & thanks for the feedback.