Get instant live expert help on How do I replace text in excel formula
“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
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
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
Can you replace text in a cell (if repeated) with different options in one formula?
For example : My age is (Variable), I live in (Variable) and have (variable) child. Can I replace 1st variable with X, second with Y and third with Z?
Solved by S. W. in 23 mins
I need a formula excel find in string of word and replace only that text but keeping the other words.
For example: find "apple" and replace that with "Red"
Apple Banana Orange
to
Red Banana Orange
Solved by A. F. in 12 mins
I have a large excel file and one column filled with duplicates. I'd like to find and replace all the cells containing the same long text, but it's unable to replace it.
Solved by V. H. in 20 mins