When I try to use Find and Replace in Excel 2013 by entering a colon into the 'Find what' field and any text into the 'Replace with' field I get "That function isn't valid" error on clicking 'Replace All'.
I am guessing that the colon is some kind of special character or something. Is there an escape character or a certain type of quotation marks or square brackets I should be using?
Update I think it might relate to the fact the field starts with an @ symbol. But I want that there, I just don't want the colon at the end
Update 2
Thanks @Jerry I did try using a tilde and it does find the cells as before but also as before the same error message shows. Interestingly if I delete the colon myself in the cell then hit Enter, the same error message shows
~:
. The~
is the escape character in excel.'
is the escape character.~
as @Jerry said