Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text searching in Excel?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text searching in Excel?
Bernard,
You have just made my job a thousand times easier. Thank you very much for your help. The Edit / Find option was exactly what I was looking for. Unfortunately, I am using a language version of this software that is not my mother tongue. Thanks for the pointers. Svatopluk "Bernard Liengme" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text searching in Excel?
You are most welcome!
good luck -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Svatopluk" wrote in message ... Bernard, You have just made my job a thousand times easier. Thank you very much for your help. The Edit / Find option was exactly what I was looking for. Unfortunately, I am using a language version of this software that is not my mother tongue. Thanks for the pointers. Svatopluk "Bernard Liengme" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
searching for similar text | Excel Discussion (Misc queries) | |||
searching and copying text in drawing layer of excel? | Excel Discussion (Misc queries) | |||
highlight the word when excel finds text you are searching for | Excel Worksheet Functions | |||
Searching for text | Excel Discussion (Misc queries) | |||
help searching text | Excel Discussion (Misc queries) |