Thread: Find
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default 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?