I have some data that I have pulled back from an SQL server that I need to
match but they clearly do not match in computer terms as A = B.

I have two columns that I need to compare

A B
1 "Fred Bloggs" "Bloggs, Fred"


clearly I can not use =if(A1 = B1,"Yes","No")

There is a slight twist as well, when "Fred Bloggs" was entered they might
be 1 or to spaces between the names and the same goes for "Bloggs, Fred"


Can you advise what function or set of functions I would use?

Many Thanks

Mark