Comparing parts of strings

Question

I am trying to compare two cells with similar texts eg: Cell A1: original_content Cell B1: orig_cont

I want to be able to compare A1 and B1 and get the comparison result to be "TRUE"

I am trying to use wild card in MATCH function after splitting the cell (text to columns), but I want to depend on using a formula.

What language? In excel formulas? – Rohlex32 Aug 11 '17 at 15:48 — Rohlex32, Aug 11 '17 at 15:48
@ScottCraner thank you for the suggestion. It works. – vnkrishna Aug 11 '17 at 16:02 — vnkrishna, Aug 11 '17 at 16:02
@Rohlex32 yes. Using excel formulas. – vnkrishna Aug 11 '17 at 16:06 — vnkrishna, Aug 11 '17 at 16:06

score 0 · Answer 1 · answered Aug 11 '17 at 16:11

0

Try looking at this website and doing some sort of 'OR' statement in the excel formula (https://exceljet.net/formula/cell-contains-specific-text)

=ISNUMBER(SEARCH(A1,B1)) OR ISNUMBER(SEARCH(B1,A1))

answered Aug 11 '17 at 16:11

Rohlex32

1 Answers1