+ Reply to Thread
Results 1 to 6 of 6

Turn blank cell to hyphen in particular cell

  1. #1
    Forum Contributor
    Join Date
    10-09-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    119

    Exclamation Turn blank cell to hyphen in particular cell

    Hello all, this should be easy but...

    I want to add a hyphen to 2 particular cells if they are blank. The form is populated from another software package with dimensions. If Columns D and E have any blank cells, want to insert a hyphen. Can't use VB because the particular software package will only output to a template with .xlt

    If can't do with Conditional Format, then okay I can tell the inspectors to use add by hand

    See attached.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Turn blank cell to hyphen in particular cell

    Hi,

    Based on what criteria do you want to check for blank cells in cols D & E from row 8 onwards? You can use the IFERROR condition in Excel for this appropriately.
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  3. #3
    Forum Contributor
    Join Date
    10-09-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    119

    Re: Turn blank cell to hyphen in particular cell

    Yes, that is what I want to do. How to use IFERROR condition?

  4. #4
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Turn blank cell to hyphen in particular cell

    The syntax of IFERROR function is as below :

    IFERROR(condition,<if error then return this value>)

    In your case, the IFERROR condition would look like : IFERROR(condition, "-")

  5. #5
    Forum Contributor
    Join Date
    10-09-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    119

    Re: Turn blank cell to hyphen in particular cell

    Can this be done with a conditional format. If a cell in D or C column is blank, insert a hyphen? What would be the code?

    If that can't be done, then I'll use a manual shortcut

  6. #6
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Turn blank cell to hyphen in particular cell

    Just a good old IF condition would suffice here :
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    If you want to go for IFERROR, ISBLANK would not work as intended :
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    will give you TRUE if D2 is blank, FALSE if otherwise. In other words, IFERROR would not work.

+ 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: 2
    Last Post: 03-01-2013, 04:33 PM
  2. Replies: 3
    Last Post: 11-03-2009, 03:06 PM
  3. How to look up a cell with that includes a hyphen (-)
    By excellicious in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-03-2008, 11:00 PM
  4. [SOLVED] Entering a hyphen into a cell
    By Goodwin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-30-2006, 05:45 PM
  5. Replies: 2
    Last Post: 04-01-2005, 08:56 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