+ Reply to Thread
Results 1 to 2 of 2

fill blank values / expression

  1. #1
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    fill blank values / expression

    Hi all,

    Does anyone know how I can fill blank values in a column with a certain description?

    Is that possible with expression?

    Greetings,

    Danielle

  2. #2
    Registered User
    Join Date
    04-26-2012
    Location
    Norwalk, CT
    MS-Off Ver
    Excel 2003
    Posts
    45

    Re: fill blank values / expression

    You can run an update query. Under Create, Query Design - select the table that contains the blank values. Under Design, change the query type to Update. Pull in the field that that blanks in it. For criteria, it's typically either "Is Null" (without quotes) or "" (just two quotes), and then in the Update To: put whatever you want.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 04-11-2013, 01:02 PM
  2. Fill blank cell with established values
    By emmysou in forum Excel General
    Replies: 2
    Last Post: 08-29-2011, 12:01 PM
  3. How to fill blank cells with different values in a column
    By intermine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2010, 12:43 AM
  4. Macro to Fill Blank Cell with Values above.
    By floridagunner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2007, 02:51 PM
  5. Help: How do I fill a column with values if it is blank?
    By limshady411 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-14-2005, 05:45 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1