cannot search in excell

  Lord Justice 10:08 08 Sep 2006

i have entered a number of client details into an excell spreadsheet.
Each cleints names and corresponding reference number is listed in fields.
occasionaly i need to search for a particular name however the find facility will not allow this.
It will not find any name in the sheet at all.
Could you please help me with this proble.
Thanks you in advance.

  johnnyrocker 10:10 08 Sep 2006

do you get an error when trying to use search? what os?


  Lord Justice 10:15 08 Sep 2006

Well i do not get an error but it simply says not found.

I am using win xp


  ArrGee 10:26 08 Sep 2006

If you are searching for the name Brown (as an example), try typing in *bro*

  Noldi 12:35 08 Sep 2006

You could try auto filter

Select all active cells (A1 > Ctrl+Alt+End) then Data > Filter > Auto Filter then search the name in the drop down list.


  Noldi 12:39 08 Sep 2006

Sorry should have mentioned then you can do a custom search.

EG - equals B* for Brown etc

  Lord Justice 18:07 21 Sep 2006

Thank you guys all sorted now

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?