Want to find and replace '@ by @

[ShreedR]

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

[#2]

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

[#3]

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.

[#4]

@ShreedR 

That's only with macro as explained here Searching for Leading Apostrophes