Microsoft Office Forums - View Single Post - Matching a word with variants

Thread: Matching a word with variants

View Single Post

Old

01-12-2019, 10:42 PM

gpktm

gpktm is offline

gpktm uses Windows 10

Windows 10 gpktm uses Office 2010 64bit

gpktm uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Nov 2015

Posts: 7

gpktm is on a distinguished road

Default

Matching a word with variants

Hi all

I need a function where Excel can identify variants of a word. In my example I want Excel to identify the word "1 & OVER" but I have variants of this word like "1 & OVER 1.5", "1 & OVER 2.5", "1 & OVER 3.5" and "1 & OVER 4.5"

I tried to do it by using OR but I had no luck.

Attached Images

2019-01-12_14-14-05.png (38.6 KB, 37 views)

Reply With Quote