View Single Post
  #6   Report Post  
swatsp0p
 
Posts: n/a
Default

One other option, working from the "Find" option...

Insert a blank column just to the left of your Names column. enter this
formula in the first row with names and copy down the entire range of names:

=LEFT(B2,1)&"xz"

This assumes your names are in col B and begin in row 2, adjust the B2
reference as needed.

Then, do a Find for Zxz (not likely to have other combinations of xz in your
list)

HTH

"Carol" wrote:

Thanks for your input.
Carol