Find function

[Jahunga]

Hi,

I am trying to build a spreadsheet that contains a search function e.g
If a user types text into a cell a range of data is then looked up an
any text strings that contain the typed text are returned in a table.

The issue I have is that I can only make this work by using either th
left right or mid functions. Ideally I would like the formula to b
(in laymans terms).......if the typed text is contained anywhere in
text string please return the whole text string.

Any ideas???

To make this clearer for you all below is an example of how i
currently works,

If a user types in Basset, my formula counts the length (Len) of th
typed text (in this case 6), the first six characters from each entr
in my data page are returned (using the left function), these are then
compared to the typed text (basset) if they match they are then include
in my table.

The data I am using are addresses that have been entered incosistentl
e.g. either 11 Basset or Basset 11, this is why I need to search th
whole text string as I would want the users to see all Bassets (ther
could be more than 50 on each street) contained in the data list.

Ctrl F is not an option on this.

Any help would be most appreciated

 

[LanceB]

It sounds like you are looking at using the

Find
or
search

functions. eg find("yourtest","in this text")

Lance

 

[Jahunga]

Thanks, had just found the search function and it works perfectly