Forum Discussion
Want to find and replace '@ by @
I would like to know if it is possible to find and replace '@ character by @ I am able to do '= by = and '- by - and '+ by + It is not allowing me to do replace '@ by @.
I think it is a limitation. Interesting. If you put the @ symbol in the middle of a text, it will be found and replaced. But not at the start. This is unrelated, because it doesn't seem to make a difference in the "Find and Replace" routine, but you can use =CHAR(64) in some instances to put the @ sign into a cell......