There are some ?
in a column content, now i want to replace it with a batch. when i Ctrl+F,put the ?
in the replace box.then click ok, it shows the formula is too long。 how do i do? thank you
-
What tool are you using for this search and replace? If you can to regex replaces its a simple s/\?/STUFFHERE/g– NickMar 23, 2012 at 23:18
-
You might need to include some screenshots of data and dialog interaction before this will make sense to someone else.– sarnoldMar 23, 2012 at 23:19
-
@Nick, the question specifically mentions "excel" in the tags, and "ctrl+f" in the text. I think the "tool" being used is pretty clear - it's the "Find" dialog in Excel itself, which is why the question is off-topic.– Ken WhiteMar 23, 2012 at 23:19
-
Whoops, my mistake, I didn't see that you had tagged it with excel.– NickMar 23, 2012 at 23:26
Add a comment
|
1 Answer
You need to escape the ?
with a ~
, otherwise the ?
is used as a wild card. That is, put ~?
in the Find What
box
-
1i am sorry it doesn't work. i want to replace ? to no content.namely,delete it. i used ~? it can't replace with null content Mar 24, 2012 at 1:22
-
1
-
This is the right answer. I accidentally upvoted the comment that said it doesn't work and can't remove my upvote, so please ignore it. Mar 24, 2012 at 14:52