Exact text search in a range of cells

Pecoflyer · #6 01-17-2023, 01:43 AM

Quote:

Originally Posted by Reyaaz

Thanks for your response, Pecoflyer.

In the attached example, the user types HR into the search box and a number of rows are pulled up which include HR.

A17 is fine as a search result, as it includes HR as a single word.

C15 and B16 are not, as they only include the word through, and not HR.

The info is gathered from the second sheet.

As I said, please post a sample sheet NO PICS !

OTOH your problem seems to be solved somewhere else . Please read A message to forum cross posters - Excelguru

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create a clickable text box to jump to a range of cells	sahara	Excel Programming	4	09-07-2017 10:56 AM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug)	slaycock	Word VBA	0	02-18-2017 07:00 AM
Search Range Within Cell or Cells	COEngineer	Excel	1	06-01-2016 11:50 AM
Search and reduce the range of a text selection	paik1002	Word VBA	1	12-17-2015 04:51 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM