Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 04-21-2015, 08:23 AM
Pstloui Pstloui is offline Find and Replace is not working Windows 7 32bit Find and Replace is not working Office 2010 32bit
Novice
 
Join Date: Apr 2015
Posts: 4
Pstloui is on a distinguished road
Default Find Function Not Working Solution

All, I have searched MSOfficeForums as well as other sites for a solution to this issue. When I noticed the sporadic problem occur, the only solution was to save, exit, re-open. Then, Find would work for a short while, then stop. Yes, I tried all of the suggestions, such as look in values, match case, match entire cell contents, but no luck.

Finally, I dropped the entire spreadsheet into Notepad and pasted back into Excel. Now Find works properly. The data was generated from a mainframe ASCII text file (yes ASCII, through SAS), then imported into Excel. This may be part of the problem, I don't know. Anyway, this seems to be the ONLY solution.

Last edited by Pstloui; 04-21-2015 at 08:45 AM. Reason: wrong forum
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
help with find and replace sjkiss Word 1 04-12-2010 08:08 AM
Find & Replace Insert Issue mipacker Word 0 02-18-2009 08:59 AM
Find and Replace Macro - A Better Way Tribos Word VBA 0 10-08-2008 03:22 AM
Find and Replace is not working How Do I Replace Nulls With Zeros? deekadelic Excel 1 08-11-2006 09:52 PM
Find and Replace is not working Find and Replace box flies off screen! M Skabialka Word 2 06-06-2006 10:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft