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

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

"Frank Situmorang" wrote:

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

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

"Mike H" wrote:

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

"Frank Situmorang" wrote:

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

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


Frank Situmorang wrote:

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

--

Dave Peterson