I feel like an idiot, but I can't seem to come up with a way to remove a " mark from a cell. It may be at the beginning, midway or at the end of the cell. Seems like a pretty simple find and replace or something, but I can't seem to get any formula to find it.
In particular, I was just trying to find the " mark's location in any given cell so I could simply do and left() and right() and then merry them together without the " in the cell. ie find(Char(34),B2) Even that is giving me an error though. Help? Excel 2007