Find string within string

[Francis Hookam]

Find string within string

There are peoples¹ initials in cells of a column. Some are one individual¹s
initials ­ SH or BN or FG and some are multiple initials ­ SH/BN or BN/FG/SH

I need to print only rows which contain particular initials, say FG.
Therefore I need to be able to hide all rows which do not include FG or
BN/FG/SH

Can you show me how to identify cells which contain one particular initial
(say FG) whether it is a single or multiple initial cell so I can write a
macro prompts an initial and the runs down the column and closes all other
rows

Thanks

Francis Hookham

 

[JE McGimpsey]

Can you show me how to identify cells which contain one particular initial
(say FG) whether it is a single or multiple initial cell so I can write a
macro prompts an initial and the runs down the column and closes all other
rows

One way is to use an autofilter. Click the Initial heading's filter
dropdown, choose Custom. Select "contains" from the dropdown and enter
FG in the textbox.

You can automate this, too - try recording a macro.