Results 1 to 8 of 8

how to change list of empty cells with a value ?

Threaded View

  1. #1
    Registered User
    Join Date
    01-06-2011
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    3

    how to change list of empty cells with a value ?

    [Excel2003] If is not so easy to input repeated value to a different cell location.
    And so much moving cursor and pasting to do the job! Is there any solution ?

    if this is the selection of cells, and "-" means empty, new value to be replace = "x
    "
    a
    -
    -
    b
    c
    -

    becomes

    a
    x
    x
    b
    c
    x

    how to code it using the current region to replace current empty cell with "x" ?

    thanks for helping hands! I really need this to speed up my work!
    Last edited by johan3000; 01-07-2011 at 12:22 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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