Go to ->blank not working

Mar 11th, 2002, 11:36 AM

Hello,
I have problem selecting the blank cells in a column
First, I fill down the whole column with a if formula.
Then, I go to copy/paste special->values to clear the formula
Finally, I go to GOTo->special->blank, but it still can't select the cells which don't have the values in it
Did I miss any steps?
Please help
Thank you in advance

Mar 11th, 2002, 11:46 AM

When I tried to fill down the column by double clicking the black cross on the lower right corner of a cell and it didn't work.
So I just drag the cell down. Could that cause any problems?
Thanks

Eli Weiss · Mar 11th, 2002, 11:50 AM

Quote:

On 2002-03-11 10:36, Anonymous wrote:
Hello,
I have problem selecting the blank cells in a column
First, I fill down the whole column with a if formula.
Then, I go to copy/paste special->values to clear the formula
Finally, I go to GOTo->special->blank, but it still can't select the cells which don't have the values in it
Did I miss any steps?
Please help
Thank you in advance

Maybe that your cells still contains spaces and they are not blanks. Perform search for spaces or try to find the first code by
=code(A1,1) for blank in A1. if you get 32 then it is a space character.
Eli

Mar 11th, 2002, 11:58 AM

I entered =code(a1) and it gives me #VALUE
So, what does it mean?

Eli Weiss · Mar 11th, 2002, 12:17 PM

Sorry
I quit

Mark W. · Mar 11th, 2002, 12:30 PM

Select an unused cell, type =, select 10-20 cells of your troublesome column of data, press F9, copy the results from the formula bar and paste into a reply posting.

Mar 11th, 2002, 12:40 PM

Hi Mark
I used the step you showed me a couple of days ago
-Select the whole column
-go to Data->Text to Columns->Finish
Then I go to GOTo->special->blanks and it works
What does Text to Columns do anyway?Its very useful

Mark W. · Mar 11th, 2002, 12:43 PM

Quote:

On 2002-03-11 11:40, Anonymous wrote:
Hi Mark
I used the step you showed me a couple of days ago
-Select the whole column
-go to Data->Text to Columns->Finish
Then I go to GOTo->special->blanks and it works
What does Text to Columns do anyway?Its very useful

It parses the column, removing trailing spaces. If a cell contains nothing but spaces it empties the cell. It also gives Excel another "look" at the values in the cells. If it finds "10" or "3/11/02" it will coerce these text values to a number and date value respectively.

[ This Message was edited by: Mark W. on 2002-03-11 11:44 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 11:36 AM	#1
Guest Posts: n/a	Hello, I have problem selecting the blank cells in a column First, I fill down the whole column with a if formula. Then, I go to copy/paste special->values to clear the formula Finally, I go to GOTo->special->blank, but it still can't select the cells which don't have the values in it Did I miss any steps? Please help Thank you in advance

Mar 11th, 2002, 11:46 AM	#2
Guest Posts: n/a	When I tried to fill down the column by double clicking the black cross on the lower right corner of a cell and it didn't work. So I just drag the cell down. Could that cause any problems? Thanks

Mar 11th, 2002, 11:58 AM	#4
Guest Posts: n/a	I entered =code(a1) and it gives me #VALUE So, what does it mean?

Mar 11th, 2002, 12:17 PM	#5
Eli Weiss New Member Join Date: Feb 2002 Posts: 15	Sorry I quit

Mar 11th, 2002, 12:30 PM	#6
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Select an unused cell, type =, select 10-20 cells of your troublesome column of data, press F9, copy the results from the formula bar and paste into a reply posting.

Mar 11th, 2002, 12:40 PM	#7
Guest Posts: n/a	Hi Mark I used the step you showed me a couple of days ago -Select the whole column -go to Data->Text to Columns->Finish Then I go to GOTo->special->blanks and it works What does Text to Columns do anyway?Its very useful