Go to ->blank not working
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Go to ->blank not working

  1. #1
    Guest

    Default

     
    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

  2. #2
    Guest

    Default

    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

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Guest

    Default

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

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry
    I quit

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  7. #7
    Guest

    Default

    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

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com