How do you find if the last character in a string is a quotation mark?
If Right(Range("A1").Value = """ Then
If I enter this as above it will not work. I have a unique case that many cells will have a quotation mark as the last character, I can not prevent this but I do need to capture the cell address and do some code.

Any help is appreociated!