Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2014, 12:54 AM
fieldhaven fieldhaven is offline Find/Replace is not working - Excel 2010 Windows 7 64bit Find/Replace is not working - Excel 2010 Office 2010 64bit
Novice
Find/Replace is not working - Excel 2010
 
Join Date: Feb 2014
Posts: 2
fieldhaven is on a distinguished road
Default Find/Replace is not working - Excel 2010

When I do a find and replace, the find function works find but the replace is not working. When I click on replace the data in the cell does not change. When I use replace all I receive the message that X number of replacements were made but the data in the cells remains the same.



I have all the cells formatted as text because I am working with numbers that I want to be seen as text.

Any ideas on how to correct this?
Reply With Quote
  #2  
Old 02-19-2014, 04:51 AM
macropod's Avatar
macropod macropod is offline Find/Replace is not working - Excel 2010 Windows 7 32bit Find/Replace is not working - Excel 2010 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,434
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Without seeing the worksheet containing the data, and what you're using for the Find/Replace expressions, it would be difficult to diagnose the problem. Can you attach a workbook to a post with some representative data (delete anything sensitive) plus a description of the Find/Replace expressions? You do this via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-19-2014, 08:30 AM
fieldhaven fieldhaven is offline Find/Replace is not working - Excel 2010 Windows 7 64bit Find/Replace is not working - Excel 2010 Office 2010 64bit
Novice
Find/Replace is not working - Excel 2010
 
Join Date: Feb 2014
Posts: 2
fieldhaven is on a distinguished road
Default Problem Solved

I figured out the issue. It seems that even though I had formatted the columns as text Excel was still seeing the cells as numeric. So when I replaced 244 with 244.0 the "0" was truncated in spite of the text format. I changed my replace statement to '244.0 and it now works. I've attached a print screen to illustrate the before/after.

Thanks!
Attached Files
File Type: docx Find and Replace Codes.docx (86.4 KB, 3 views)
Reply With Quote
Reply

Tags
find & replace

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find/Replace is not working - Excel 2010 Find and Replace is not working Brigitte Word 6 04-21-2015 08:45 AM
Find/Replace is not working - Excel 2010 Find and Replace not working alance Word 2 01-24-2014 02:11 AM
Find/Replace is not working - Excel 2010 Find and Replace using Excel range dmarie123 Word VBA 15 04-02-2013 07:54 AM
MS Word Find and Replace not working allenglishboy Word 10 07-25-2012 08:05 AM
Find/Replace is not working - Excel 2010 Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:37 AM.


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