View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Text searching in Excel?

A) Have you experimented with Edit | Find ?

B) Would you like to be able to enter name in a cell and have address
returned? If so have a look at VLOOKUP. But you must have a consistent way
of entering the names.

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Svatopluk" wrote in message
...
Hello all,

I use Microsoft excel for maintaining a list of names of customers and
other
information. This list is growing (hundreds of names now) and I am
wondering
if there is any text search option, like in Word. I would like to search
for
a customer's name and go to their row in the list. Is this possible?

Thanks for your help
Svatopluk