Hi,

I tried to replace the "~" character with nothing but could not do it. The
Search and Replace option in Excel will not cooperate. What could be wrong?
There are no option to say that one wants to use wild characters.
I use Excel 2002 and 2003.
Thank for any help.

--
Jac Tremblay

Use ~* to find/replace *
~? to find/replace ?
~~ to find/replace ~

Jac Tremblay wrote:

Hi,

I tried to replace the "~" character with nothing but could not do it. The
Search and Replace option in Excel will not cooperate. What could be wrong?
There are no option to say that one wants to use wild characters.
I use Excel 2002 and 2003.
Thank for any help.

--
Jac Tremblay

--

Dave Peterson

Hi Dave,
That is so simple when one knows...
Thank you very much.
--
Jac Tremblay


"Dave Peterson" wrote:

Use ~* to find/replace *
~? to find/replace ?
~~ to find/replace ~

Jac Tremblay wrote:

Hi,

I tried to replace the "~" character with nothing but could not do it. The
Search and Replace option in Excel will not cooperate. What could be wrong?
There are no option to say that one wants to use wild characters.
I use Excel 2002 and 2003.
Thank for any help.

--
Jac Tremblay

--

Dave Peterson

Ps. I searched for Wildcard in xl2003 and got this as the top item:

Wildcard characters
The following wildcard characters can be used as comparison criteria for
filters, and when searching and replacing content.

Use To find
? (question mark) Any single character
For example, sm?th finds "smith" and "smyth"
* (asterisk) Any number of characters
For example, *east finds "Northeast" and "Southeast"
~ (tilde) followed by ?, *, or ~ A question mark, asterisk, or tilde
For example, fy91~? finds "fy91?"


Jac Tremblay wrote:

Hi,

I tried to replace the "~" character with nothing but could not do it. The
Search and Replace option in Excel will not cooperate. What could be wrong?
There are no option to say that one wants to use wild characters.
I use Excel 2002 and 2003.
Thank for any help.

--
Jac Tremblay

--

Dave Peterson

Thanks again, Dave.
--
Jac Tremblay


"Dave Peterson" wrote:

Ps. I searched for Wildcard in xl2003 and got this as the top item:

Wildcard characters
The following wildcard characters can be used as comparison criteria for
filters, and when searching and replacing content.

Use To find
? (question mark) Any single character
For example, sm?th finds "smith" and "smyth"
* (asterisk) Any number of characters
For example, *east finds "Northeast" and "Southeast"
~ (tilde) followed by ?, *, or ~ A question mark, asterisk, or tilde
For example, fy91~? finds "fy91?"


Jac Tremblay wrote:

Hi,

I tried to replace the "~" character with nothing but could not do it. The
Search and Replace option in Excel will not cooperate. What could be wrong?
There are no option to say that one wants to use wild characters.
I use Excel 2002 and 2003.
Thank for any help.

--
Jac Tremblay

--

Dave Peterson