Search function (text or numerical)

  • Thread starter Thread starter marciac
  • Start date Start date
M

marciac

Hi all
Just trying to figure out how to implement a search function, as
follows...

sheet1 contains all the data to be searched;
example:
one cell in this sheet contains "BMS-1865-1701-CZ05"

How can I search for this data, based on partial search criteria ? for
example my criteria would be : "1701-CZ"

I really need to use excel on this one...
Thnx!
 
Do you know the range of cells in which the data might be found. Is i
one row or column or a larger range?

Which data do you want to return, e.g. the cell immediately to th
right
 
What's wrong with selecting your range,
then Edit|Find
click on the Options button (if you don't see the options) and make sure that
match entire cell contents is not checked.
 
Back
Top