Hi KC,
The formula I suggested counts the characters, then compares the first half
to the second half. If there are extra spaces, they mess up the count.

You can clean up your data with =TRIM(SUBSTITUTE(A2,CHAR(160)," "))
Put this in an adjacent cell, then copy down. It will remove leading and
trailing spaces, and the nasty non-breaking space character which is
sometimes present.
Then apply my other formula to cleaned-up data.
If it gives you what you want, copy the good data and Paste Special Values
over the original data, and delete the columns you used in the process.
Regards - Dave.

"kacey28" wrote:

Dave, I wasn't aware spaces could cause a problem. Yes, the format that the
outsourced company uses in thier spreadsheet does include unnecessary leading
and trailing spaces.

Would it work best if I run the Trim function and then run your formula from
the clean data?

"Dave" wrote:

Hi,
My formula works ok for me. Try typing Jerry White Jerry White into A2 and
apply the formula.
Does your data have leading or trailing spaces that you're not telling us
about?
Regards - Dave.