Quotation mark?

How do you find if the last character in a string is a quotation mark?

Please Login or Register  to view this content.

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!

Try

Please Login or Register  to view this content.

Oh hell, that was too easy!

Thank you!

Excel 2007 simply will not except this format

Please Login or Register  to view this content.

But it does when formatted as

Please Login or Register  to view this content.

So, how do I replace the quotation mark, this will not work.

Please Login or Register  to view this content.

I have to find the quotation mark, place the text value of the cell in a variable, remove the quotation mark and concatenate with another cell. I have it all less removing that darn quotation mark.

Don't forget to specify the number of characters

Both the VBA and worksheet versions default to 1

So, how do I replace the quotation mark

You mean remove a trailing quote if there is one? Maybe

Please Login or Register  to view this content.

Thank you, why can't help just state that?

For those who wonder what I am doing, here is the bit of code.

Please Login or Register  to view this content.

Thanks to all for the help!