Cell Check With Numbers, Symbols and Characters

Hello,

I have spent some time searching for a past thread related to my question and have only found a few forums with similar questions but not the same. I then tried using some VBA online lessons and such but have had no luck - I appreciate any help provided.

I have a spreadsheet that is already sorted and does not require further sorting. I essentially require the macro to take the contents of a cell and check it with the cell below it. The problem is the cells contain a mix of mostly numbers, symbols, and a consistent capital letter.

'1120500+1256-R
'1086900+1247-R

What would be the command to check these two strings?

Thanks a million,

Alex