ms excel find and replace @ symbol results in broken formula
- by Loopo
I'm trying to search and replace in excel, the column is formatted as 'Text'.
Find: [@
replace with: @
Whenever this finds a match at the start of a cell i.e the cell contents start with [@
and tries to replace that with @ the result is an error 'This function is not valid'
I guess that since the @ operator is for references, this is causing the cell to be interpreted differently (not as text anymore)
How do I make this replacement work?
Copy/paste into another program is not a good option because some of the cells contain line-breaks.