Simple Find and Replace Question
Is this question still unanswered?
"Elessvie" wrote:
I meant to add that I am able to set Look In Values in the Find pull-down,
but in the Replace With pull-down, it shows only Formulas (Values is not
listed).
What am I doing wrong?
Any help really appreciated!
-Lynne
"Gary''s Student" wrote:
Specify look in values
--
Gary''s Student - gsnu200779
"Elessvie" wrote:
Hello, folks!
I'm trying to find and replace a word with another in a column containing
text. I'm using Ctrl-H, Find = reciept (for example), Replace with =
receipt. This locates a cell containing the word, but when I press Replace,
Excel displays the error message "Formula is too long."
I've tried formatting the column as General and as Text and get the error
message with both. I've searched Excel Help and this discussion group, but
haven't been able to find this specific issue addressed, so I'm thinking it's
probably something really obvious!
Thank you for any help.
-Lynne
|