phantom cells

[•Daniel•]

I have several columns each with numbers and blank spaces I like that I could sum this columns horizontally and make a total column and that the result of blanks sum still blank, that because each rows refers to a code, so I need to keep blanks and just sum horizontally.

So I made a conditional, it works fine, however I like to go by with contrl+down so I can stop at each existence, but since there is conditional it take me from beggining to end of column without stoping at numbers.

I ctrl+c ctrl+v the hole column and just pasted values, the conditional is gone, the blank cells look blank but excel recognizes them as constants, meaning ctrl+down stiil take me from begining to end.

Sorry for my eanglish, I already posted this same question in spanish, just hoping to recibe a faster answer.

thx

 

[•Daniel•]

stoping at each cell and hitting delete it works, it eliminates the "phantom constant" but the columns I have are 9000 rows big so I'm sure there is a fastest way even whitout macros.

 

[•Daniel•]

umm yes as i thouth it was easy just did it

Just hilight hole column f5 special constants, unchek numeric and it'll go to all except the numers I want to Keep, f2 and delete and the ctrl+enter.