Formula or Function to Find "blank cells" with " ' "; Replace with true Blank Cells

[Hollando]

Hello all,

Although, I was working this into a Macro, I was wondering if anyone had a non-vba solution as well? Basically, I have cells with " ' " due to an extract from our ERP system here at the office. As you can imagine this is quite irritating.

My question: Is there a way to identify cells with " ' ", the remove the " ' " to create a true blank cell.


Any guidance would be greatly appreciated.

Regards,

Hollando

 

[Comfy]

Duplicate Thread: http://www.mrexcel.com/forum/excel-questions/706319-formula-function-find-blank-cells-%3B-replace-true-blank-cells.html

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).