Get instant live expert help on find and replace function in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi, I am having trouble using find and replace in my worksheet. I am trying to find and replace a string of text that is part of a larger portion of text in the cells of one column of the worksheet. The problem is that the find and replace function is replacing the entire cell contents, not the string of text specified in find and replace.
Solved by K. J. in 30 mins
I need to find and replace text in an excel spreadsheet base on content variables. The find and replace is larger than the 256 character limit.
Solved by F. L. in 26 mins
i need help with doing a find and replace in excel
Solved by F. B. in 25 mins
Questions are about "Find" and "Replace" features under "Edit" on tool bar. I can "Find" a $ amount (ie: $3.50) in cells ONLY if I change "Look In" from "Formulas" to "Values." BUT, I when I click on "Replace" and the next screen comes up, the "Look In" drop down menu disappears and if I try to "Replace All" my $3.50 with $3.00 (for example) it says "Microsoft Excel cannot find matching data to replace." So, how do I "Replace All" for large quantity of $ amounts? Also, I used to be able to "Find All," NOT Just "Find" or "Find Next." How do you now "Find All" in current Excel version? I used to be able to do both in my older versions of Excel.
Solved by E. D. in 20 mins
I need to find and replace a number on a price sheet I made, the the number I want to find and replace was created by a formula.
Solved by A. F. in 19 mins