Is there an efficient method to clear cells that look blank but are flagged non-blank?

[gravanoc]

For an unknown reason the area I copied and pasted to a new sheet has a cells that appear blank but are flagged as having data. The sheet I copied from was protected, which might have some bearing on this, I guess. I've experienced this issue before, and would like to know if there is a process to quickly turn those fake blanks into real blanks. This is because I'd like to use the Goto Special command to select the constants in that range, but they are currently flagging the fake blanks as constants. It's a large area, so simply selecting selecting all the cells and clearing them is tedious.

 

[kevin9999]

Do the rogue cells contain spaces? And if so, would a Trim() adversely affect other cells?

 

[footoo]

clear cells that look blank but are flagged non blank - Google Search

www.google.com

 

[Alex Blakenburg]

Do you have formulas in the new sheet ?

 

[Fluff]

If you had formulae in the copy range & then copy/pasted as value all cells where the formula returned "" will have a null string in them.
How are you doing the copy/paste, manually, or via code?

 

[Sufiyan97]

This might help

https://answers.microsoft.com/en-us/msoffice/forum/all/getting-rid-of-empty-cells-that-appear-blank-but/cbe3d36a-8264-45f2-aa9c-dfacf06313e8