Take the 2-minute tour ×
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 stackoverflow.com 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
add 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

share|improve this answer
1  
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
1  
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
add comment

Your Answer

 
discard

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