Find "*" in excel sheet

[vipulgos]

Dear all I am not able to find the "*" (multiplier) in my work sheet by find command, how to do this? I want to change all * by x for easy reference to others.

 

[dafan]

Try Substitute:

=SUBSTITUTE(A1,"*","x")

Edit: Hm I now see what you mean. You mean Find via Edit menu...Can't find it either

 

[vipulgos]

without vba possible?

 

[Padawan]

You can use the find command.

Edit-> Find, Find What = * (No quotes), Look In formulas.

But if you are trying to replace the * with an X in a formula, Excel will give you a string. It won't be able to do any actual multiplication.

HTH,

 

[vipulgos]

in fact i don't want to use the formula for resul, but i want to show the formula to end user.

 

[LTunnicliffe]

If the end is to show the user the formulas in your worksheet then replace = with '=.

Loren

 

[Case_Germany]

Hi,

if you want to look for * - try in the search window:

~*

Case_Germany

 

[vipulgos]

Already I have done like '=, but still the * will remain there. I want to replace * with x only.

 

[Case_Germany]

Hi again,

search for "~*" and replace with "x" - that´s it.

Case_Germany

 

[vipulgos]

Hi again,

search for "~*" and replace with "x" - that´s it.

Case_Germany

Now it has been done, thanx a lot