Matching a word with variants

		Microsoft Office Forums > Microsoft Excel > Excel
Matching a word with variants

FAQ

Thread Tools

Display Modes

01-12-2019, 10:42 PM

gpktm

Windows 10 Matching a word with variants

Office 2010 64bit

Novice

Join Date: Nov 2015

Posts: 7

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)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Document variants	Felicc	Word	1	06-08-2018 04:48 PM
Find paragraph matching an expression in Word and exporting to Excel spreadsheet	ballpoint	Word VBA	23	03-23-2018 02:04 PM
Matching last in a list	salse	Excel	3	06-08-2016 08:08 PM
powerpoint Variants	HelpReceiver	PowerPoint	2	04-03-2015 11:55 AM
refering to the msoFileDialogueOpen variants	smndnm	Word VBA	23	07-20-2014 04:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 PM.