Find
You can create a column with the two names joined, with a formula like:
=A1 & " " & B1
And then use the menu Edit - Find. You need to assure that you look for
values, that setting can be found on the options section, in the "look in"
drop down.
Hope this helps,
Miguel.
"Roger" wrote:
I have a worksheet with 100s of names. The first & last names are on
separate cells (in the same row).
I am trying to find €śJOHN DOE€ť, how do I search for it?
|