Finding only the word OR

[JuliusV]

Attached is a sample spreadsheet with an example of what I am trying to achieve.

I am trying to identify the conjuction "or" in the string. I only want the conjuction "Or", not any sub-string of "or". For example, (asdf Orasdf sadf) would be a positive match; however, i do not want that to be included. I only want something such as (asdf asdf or) to be included because the "or" is a conjunction.

Thanks for the help!

 

[Nebu]

Hi:

No Workbook attached.

Thanks

 

[JuliusV]

Workbook Attached

 

[Nebu]

Hi:

Find the attached formulas in yellow colored columns.

Thanks

 

[JuliusV]

For address line 1, it counted (asdf Orasdf sadf) which is the same issue that I had. I am not sure how to get around that.

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[JuliusV]

Hi Nebu,

The Address Line 2 still includes words such as (OrName2); however, I have developed a solution
=IFERROR(IF(SEARCH("or ",AA3) = 1,"True",""),"")

Thanks for the help for Address Line 1!

I didnt know exact was a function in excel.

 

[John Jairo V]

Hi @JuliusV (and @Nebu)

This can be an option:
=--ISNUMBER(SEARCH(" or "," "&[@[Address Line 1]]&" "))

Blessings!

 

[JuliusV]

Thanks for the suggestion John Jairo V!

 

[Nebu]

Hi
@john Jario

Thanks you for your suggestion.

@JuliusV

I gave the formula as per the note you had given in your file saying that for Add line 1 the "Or" will be the always first 2 letters and for Add line 2 the letter "Or" will be always last 2.

Thanks