Use of COUNTA

[Guest]

Hello Experts:

After I use a copy value form the formula, then I use countA for indtending
to copy only the unempty cellc. How ever the result of the blank cell also
has been counted as unemptied cell, what's wrong with it?. I saw it is
blank, but how it counts as an unemptied cells.

Please advise

Many Thanks,

Frank

 

[Guest]

Are you sure the cells you think are blank are really empty? They may contain
spaces.

next to your date type =len(a1)

drag this down. All truly blank cells will display 0

Mike

 

[Guest]

Yes Mike.. all it shows zero

Pls. help me because I want to use a dynamic rage to copy to update my data
bank

Frank

 

[Dave Peterson]

Saved from a previous post:

If you want to see what's left in that cell after you convert ="" to values,
try:
Tools|Options|Transition Tab|Toggle Transition Navigation keys on.

Then select one of those cells and look at the formula bar. You'll see an
apostrophe. (Don't forget to toggle the setting to off.)

When I want to clean up this detritus, I do this:

Select the range (ctrl-a a few times to select all the cells)
Edit|Replace
what: (leave blank)
with: $$$$$
replace all

Immediately followed by:
Edit|Replace
what: $$$$$
with: (leave blank)
replace all