A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

windows xp search for numbers within an xls file



 
 
Thread Tools Display Modes
  #1  
Old December 31st, 2009, 04:36 AM posted to microsoft.public.excel.misc
Sgroe
external usenet poster
 
Posts: 1
Default windows xp search for numbers within an xls file

I used to have the ability to enter a numeric string in the search for "a
word or phrase in the file" however this no longer works.

I can do a search for text in excel files with results but for instance if I
search for 99669 their are no search results even if the number is in an xls
file.

Any help would be much appreciated.

Shawna
  #2  
Old December 31st, 2009, 06:00 AM posted to microsoft.public.excel.misc
Ms-Exl-Learner
external usenet poster
 
Posts: 522
Default windows xp search for numbers within an xls file

I can able to search the workbook which contains the numeric number 99669.

Locate the folder or Drive which consist the file and do right click and
select SEARCH

All part of the file name:
Mention *.xls or check whether the file format is xls or xlsx. If it is
xlsx then mention it as *.xlsx

A word or phrase in the file:
99669

Give search and now you will get the file which is having the 99669.

It’s working fine for me. (WindowsXP-Service Pack2)

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Sgroe" wrote:

I used to have the ability to enter a numeric string in the search for "a
word or phrase in the file" however this no longer works.

I can do a search for text in excel files with results but for instance if I
search for 99669 their are no search results even if the number is in an xls
file.

Any help would be much appreciated.

Shawna

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.