Want to find and replace '@ by @

%3CLINGO-SUB%20id%3D%22lingo-sub-1539458%22%20slang%3D%22en-US%22%3EWant%20to%20find%20and%20replace%20'%40%20by%20%40%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539458%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20know%20if%20it%20is%20possible%20to%20find%20and%20replace%20'%40%20character%20by%26nbsp%3B%40%3C%2FP%3E%3CP%3EI%20am%20able%20to%20do%20'%3D%20by%20%3D%20and%20'-%20by%20-%20and%20'%2B%20by%20%2B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20not%20allowing%20me%20to%20do%20replace%20'%40%20by%26nbsp%3B%40.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1539458%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542244%22%20slang%3D%22en-US%22%3ERE%3A%20Want%20to%20find%20and%20replace%20'%40%20by%20%40%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542244%22%20slang%3D%22en-US%22%3EI%20think%20it%20is%20a%20limitation.%20Interesting.%20If%20you%20put%20the%20%40%20symbol%20in%20the%20middle%20of%20a%20text%2C%20it%20will%20be%20found%20and%20replaced.%20But%20not%20at%20the%20start.%20This%20is%20unrelated%2C%20because%20it%20doesn't%20seem%20to%20make%20a%20difference%20in%20the%20%22Find%20and%20Replace%22%20routine%2C%20but%20you%20can%20use%20%3DCHAR(64)%20in%20some%20instances%20to%20put%20the%20%40%20sign%20into%20a%20cell......%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1542330%22%20slang%3D%22en-US%22%3ERe%3A%20Want%20to%20find%20and%20replace%20'%40%20by%20%40%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1542330%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F736896%22%20target%3D%22_blank%22%3E%40ShreedR%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3Bnoted%2C%20you%20can%20find%20and%20replace%20'%40%20in%20the%20middle%20or%20end%20of%20a%20cell%20but%20not%20the%20beginning.%20A%20possible%20workaround%20would%20be%20to%20copy%20the%20column%2C%20paste%20it%20as%20values%20in%20another%20blank%20column%2C%20copy%20the%20new%20column%20and%20paste%20it%20in%20the%20original%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544356%22%20slang%3D%22en-US%22%3ERe%3A%20Want%20to%20find%20and%20replace%20'%40%20by%20%40%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544356%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F736896%22%20target%3D%22_blank%22%3E%40ShreedR%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20only%20with%20macro%20as%20explained%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.tips.net%2FT003332_Searching_for_Leading_Apostrophes.html%23%3A~%3Atext%3DEven%2520though%2520you%2520may%2520be%2Cprefix%2520character%2522%2520for%2520a%2520cell.%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ESearching%20for%20Leading%20Apostrophes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

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

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.

@ShreedR 

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