Forum Discussion

ShreedR's avatar
ShreedR
Copper Contributor
Jul 22, 2020

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 @.

Formulas and Functions

3 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Jul 23, 2020

    Hello ShreedR,

     

    As mathetes noted, you can find and replace '@ in the middle or end of a cell but not the beginning. A possible workaround would be to copy the column, paste it as values in another blank column, copy the new column and paste it in the original column.

  • mathetes's avatar
    mathetes
    Silver Contributor
    Jul 23, 2020
    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......

Resources