Get instant live expert help on how to do find and replace 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
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 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
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
If I have over 20000 cells in excel, and multiple cells contain "*" how do i replace all with zeros?
Solved by C. E. in 14 mins