Find and Replace (*) - asterisk

[kshora]

I have formulas in many cells and want to replace * by division ( / ). When I use Find and Replace and enter *, it replaces everything before * which I do not want to happen. Is there any way around.
Your help is highly appreciated.
Regards
KShora

 

[Lewiy]

I think your problem is that Excel is treating “*” as a wildcard rather than the asterisk character. Try putting a tilde (~) in front of the * to tell Excel to look for the actual character.

 

[ADAMC]

Try find ~*

Replace with /

* Denotes a wildcard and so will not replace the actual value of *

 

[Dan Waterloo]

This is from http://support.microsoft.com/kb/214138

SUMMARY
Microsoft Excel uses the tilde (~) as a marker to indicate that the next character is a literal. When you use the Find and Replace dialog box to find or replace a character such as a tilde (~), an asterisk (*), or a question mark (?), you must add a tilde (~) before the character in the Find what box.

Note If you want to find or replace a tilde in a worksheet, you must type a double tilde (~~) in the Find what box.

 

[kshora]

Your replies can be summarized in one word " BEAUTIFUL"

Thanks a lot

Regards

KShora