Compare two cells then show result

**WCE_123** · 03-21-2013, 03:40 AM

Hi,

I have cell A1 with an address "The Long Road".
in Cell B1 I have part of the address "The Long"
If this is the case I would like cell C1 to show nothing.
If B1 doesn't have part of the address in it then C1 to show the full address that is in A1.

Thank you for youtr help.

Cheers

**Fotis1991** · 03-21-2013, 03:43 AM

Try in C1

=IF(ISNUMBER(SEARCH(B1,A1)),"",A1)

**WCE_123** · 03-21-2013, 04:15 AM

Thank you for quick reply but this doesn't seem to work,

Cheers

**Fotis1991** · 03-21-2013, 04:55 AM

You are welcome but works for me, in the way that you explained to us.

If you mean something else maybe it's better to upload a small sample workbook, typing manually a few expected results..