How can I write a macro so that when I compare two cells that are like this
BB ; AA+
and
AA+ ; BB

I can say they are equal. The format of the cells are always the same. Some letters, 1 space, a semicolon, 1 space and some more letters.