First & Last Name in a Single Cell Comparison Checker

[censo]

Greetings,

I have two columns (A:B) with First and Last names present in each column and I'd like to construct a function in column C that compares the entire cell contents from B:A and only indicates when it cannot discern a match for a given row.

Additional Details

- I do not require the names be parsed out into their own columns.
- If either the first or last name is detected, the result is considered a match
- If neither first or last name is detected, the result is considered a mismatch and outputs an "N"
- Middle names or initials are sometimes present. Middle names can be evaluated but initials should be ignored (so, any characters >1)
- The key cell is B, to which A will be compared for determining a mismatch (B-->A)

Basically, if any component of a name can be detected (except a single character Middle Initial), it is considered a match and does nothing (blank value)

Diagram below shows intended output

If the below is not possible, I'd entertain the next best solution that gets me close.

Thanks in advance.

- C

Book1
	A	B	C
1	Name A	Name B	Match?
2	Sara Lee	Sara Lee
3	S Lee	Sara Lee
4	Sara M Lee	S M Lee
5	Sara L	S Lee	N
Sheet1

 

[censo]

Well, I took you literally when you stated you wanted to "construct a function". The code provided does just that, and does not need to be modified to accommodate your real-world environment.

Ahh, thanks for the clarification. What I really wanted was a formula but I always thought that by definition a formula that did not calculate numbers is called a function.

With that I thank you again for your engagement. I have chosen Phuoc's solution to implement into my environment.

Happy New Year

 

[censo]

...

This is exactly what I was looking for. Thank you!

Happy new year

 

[Phuoc]

You're welcome! Happy New Year.