I have 2 column's that I wish to remove certain data from. The cells
have various lengths in data, but each column starts and ends with a
certain char I want to remove.

For instance in Column B the cell data starts and ends with a " sign.
I need these removed.

In Column C the cells all start with a " sign and end with a ");
These symbols need to be removed from the respective column data. I
have over 50,000 entries so..this is why I'm looking to automate it
with either a macro, vba, direct excel solution etc.


Any Ideas on the problem at hand?


Thanks