Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

migrated from Mar 24 '12 at 0:55

This question came from our site for professional and enthusiast programmers.

What tool are you using for this search and replace? If you can to regex replaces its a simple s/\?/STUFFHERE/g – Nick Mar 23 '12 at 23:18
You might need to include some screenshots of data and dialog interaction before this will make sense to someone else. – sarnold Mar 23 '12 at 23:19
Nick, i am using excel.thank you – user1188320 Mar 23 '12 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 White Mar 23 '12 at 23:19
Whoops, my mistake, I didn't see that you had tagged it with excel. – Nick Mar 23 '12 at 23:26

1 Answer 1

You need to escape the ? with a ~, otherwise the ? is used as a wild card. That is, put ~? in the Find What box

share|improve this answer
i 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 – enjoylife Mar 24 '12 at 1:22
Yes you can, just leave the Replace with box empty – chris neilsen Mar 24 '12 at 2:20
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. – Wayne Johnston Mar 24 '12 at 14:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.