Advanced Search - Find only exact word in string

SimoninParis

New Member
Joined
Mar 2, 2012
Messages
23
Hello fellow Excel vba fans,

I am storing around 50 fields and there will be in excess of 2000 records. This will effectively become a searchable library. Most of the fields are different categories; setting up the advanced filters and output were relatively easy to set up.

One field/column contains transcripts. I require to be able to filter entries that contain a substring with the options "including" and "exact". The including is easy. However, if I search/filter for "head", I either get all entries with "head" as well as "ahead", "heading", "headed" etc. or I get nothing! The difference being how I enter the criteria.

Am I being particularly dim? Does anyone know how I can overcome my problem? Do I need some form of alchemy involving INSTR and MID?

All/any help will be gratefully received.

Thanks in advance,
Simon
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

SimoninParis

New Member
Joined
Mar 2, 2012
Messages
23
Hi Dave,

I have tried using " head " and Chr(32) & "head" & Chr(32); they did not provide the required result....
 

Watch MrExcel Video

Forum statistics

Threads
1,122,588
Messages
5,597,042
Members
414,116
Latest member
sfullnet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top