1

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

4
  • 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, 2012 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, 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 White
    Mar 23, 2012 at 23:19
  • Whoops, my mistake, I didn't see that you had tagged it with excel.
    – Nick
    Mar 23, 2012 at 23:26

1 Answer 1

5

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

3
  • 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, 2012 at 1:22
  • 1
    Yes you can, just leave the Replace with box empty Mar 24, 2012 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. Mar 24, 2012 at 14:52

You must log in to answer this question.