Matching a word with variants

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:49 PM.