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
|