+ Reply to Thread
Results 1 to 5 of 5

Find absent string in cell

  1. #1
    Registered User
    Join Date
    01-06-2010
    Location
    Maryland, US
    MS-Off Ver
    Excel 2003
    Posts
    1

    Find absent string in cell

    The FIND function specifies a string to be found within a bigger string and the number of characters from the beginning in the cell where this function is used. However, if the string is not found, it gives an error: "#VALUE" and writes #VALUE" in the cell. But, in such case I want to insert a blank in the cell. The "On Error goto.." command does not work. Nor does an If command work. Can you all help?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Find absent string in cell

    Are you looking for a VBA program to alter cells?
    Are you looking for a formula to return a value?
    Something else?

    Can you give some examples and what you want the end result to be?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Find absent string in cell

    Perhaps =IF(ISNUMBER(FIND("xxx", A1)), FIND("xxx", A1), "")
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Find absent string in cell

    Ron,
    Something else?
    what would you have in mind?

  5. #5
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Find absent string in cell

    Sometimes what's possible isn't what they want!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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