Copying formulas that result in blanks do not copy as blank?

[Pauljj]

I use a formula like so

=IF(F8="HTL",A8,"")

This is in P3 and copied down, when I copy the range as Values to another sheet and then do ctrl+G, Special then Blanks. It cannot find the blanks. Is there a way to clear contents on the cells that have no text ?

 

[Pauljj]

Does anyone have any ideas on this ???

 

[Boller]

Instead of selecting via SpecialCells, try selecting via AutoFilter.

 

[pgc01]

Hi Paul

To clear contents on the cells that have no text in a column vector try:

Select the range (a a column vector).
Data>Text to Columns. In the first panel click Finish.

Hope this helps
PGC

 

[pgc01]

You can also use a a vba approach.

Select the range. Run this a code like this one

Sub NoContents()
    
    For Each rc In Selection
        If rc = "" Then rc.ClearContents
    Next
End Sub

HTH
PGC