software

I am using Excel 2002. I have a column that contains text. Within this text
are multiple *. I would like to replace them with nothing using the find and
replace option. The problem is when I put the * in the find filed Excel
assumes it is a wild card and replaces the entire field with blank. How do I
tell Excel the * is not a wild card but an actual character.

Use ~*

quot;Laura Bethquot; wrote:

gt; I am using Excel 2002. I have a column that contains text. Within this text
gt; are multiple *. I would like to replace them with nothing using the find and
gt; replace option. The problem is when I put the * in the find filed Excel
gt; assumes it is a wild card and replaces the entire field with blank. How do I
gt; tell Excel the * is not a wild card but an actual character.

Thanks for the tip, Mr. Carey.
--
Sincerely, Michael Colvinquot;Duke Careyquot; wrote:

gt; Use ~*
gt;
gt; quot;Laura Bethquot; wrote:
gt;
gt; gt; I am using Excel 2002. I have a column that contains text. Within this text
gt; gt; are multiple *. I would like to replace them with nothing using the find and
gt; gt; replace option. The problem is when I put the * in the find filed Excel
gt; gt; assumes it is a wild card and replaces the entire field with blank. How do I
gt; gt; tell Excel the * is not a wild card but an actual character.