How to insert @#$% with find and replace function ?

[ngotrongnhanbrvt]

When i try to replace all the letters "a" with "@#$%" it don't let me do it.
As evidenced in the picture below:
Capture.JPG
How to solve it ?
Thank you.

[Ochimus]

Following Code does it. Open the attachment and click the button on sheet.

Any letter "a"s in Col A are replaced by the four symbols:

Please Login or Register  to view this content.

Ochimus

[hrlngrv]

The @ as the 1st character makes it almost certain that your problem is Lotus 1-2-3 Transition Formula Entry.

Unless you're ABSOLUTELY INURED TO such formula entry, namely, starting all formulas with + rather than =, and entering an @ at the beginning of every function call in formulas, I'd recommend disabling that setting. To do that, click on Files tab in the ribbon, click on Options in the bottom-left to display the Options dialog. Select Advanced in the left hand section of that dialog. Scroll the right hand side of that dialog all the way to the bottom. If the checkbox for Transition formula entry is checked, uncheck it. Then click OK.

[bebo021999]

Try '@#$% (with leading ')

[bebo021999]

Duplicated post.