If isnumber search function returning false

**hawkwolf** · 08-14-2018, 01:59 PM

Hello I am new to this forum and mostly self taught on excel. I am trying to learn different functions to help speed up my workflow and have discovered the =IF(ISNUMBER(SEARCH function. However when I try it out, it keeps saying false. Even if I just break it down to search it is still returning false and a bit confused by this.

I started with =IF(ISNUMBER(SEARCH("EOC",$G2)),"Yes","No") to test it out to make sure it works but returns false. G2 cell contains "CDC, EOC C/W"

When I reduced it down to =SEARCH(K4,G2) K4 having "EOC" in it, it still returned false.

If it matters, using excel 2013.

**CK76** · 08-14-2018, 02:06 PM

I'd recommend uploading sample file.

I suspect, that you might have non-printing characters somewhere between E & O or O & C in G2.
Which causes SEARCH on "EOC" to return false.

**hawkwolf** · 08-14-2018, 02:15 PM

Ok so when I went to create a sample, it works. So obviously it isn't the formula but a setting in the excel sheet somehow?

EDIT: by sample I mean I opened up a fresh excel to create a mini version of what I was working on. The original is a table created by somebody else previously and I have been trying to streamline it.

**CK76** · 08-14-2018, 02:29 PM

Try doing following.

In some out of way range enter following formula.
=MID($G$2,COLUMN(A1),1)

And copy across. If you see EOS in contiguous cells, then it's something else that's wrong with workbook. If you see some seemingly blank cells in between...
It's likely non-printing character that needs to be removed from string in G2 (Using... TRIM, CLEAN and/or SUBSTITUTE).

**hawkwolf** · 08-14-2018, 02:34 PM

Now I am pretty sure it is the workbook. It is giving me a certificate error when I paste in that formula in some out of the way place nearby ("This application experienced an internal error loading the SSL libraries") I am just going to recreate the table in a fresh excel. Thank you for the help ^.^

**CK76** · 08-14-2018, 02:36 PM

You are welcome and good luck.

If isnumber search function returning false

LinkBack

Thread Tools

Rate This Thread

Display

If isnumber search function returning false

Re: If isnumber search function returning false

Re: If isnumber search function returning false

Re: If isnumber search function returning false

Re: If isnumber search function returning false

Re: If isnumber search function returning false

Thread Information

Users Browsing this Thread

Similar Threads

IF AND ISNUMBER SEARCH Function. Keeps returning false value even if true.

Multiple search terms: (ISNUMBER(SEARCH(". VALUES",1:1))),FALSE)

ISNumber combined with MID returning FALSE if blank

[SOLVED] IF(ISNUMBER(SEARCH function

[SOLVED] ISNUMBER function in formula not returning expected value

IF(ISNUMBER(SEARCH(Find Text, Within Text)),True, False)

ISNUMBER(SEARCH Function

Bookmarks

Bookmarks

Posting Permissions