problem finding string using .find method when string to be found contains ~ (a tilde)

**welchs101** · 07-01-2013, 07:08 AM

hi,

I am enclosing a macro. This macro basically looks in the first column for the string located in cell (row 2 column 1). But because this cell contains a "~".........(i think) the find method does not find it..........am i doing something wrong?

Also, how to get this to work?

**snb** · 07-01-2013, 07:14 AM

Please Login or Register  to view this content.

**Debraj Roy** · 07-01-2013, 07:17 AM

Formula:

Please Login or Register  to view this content.

oops.. snb already there..

BTW same rule is applied for "*" also...

**welchs101** · 07-01-2013, 07:25 AM

i tried it and it worked.............so thanks!!!!!!!!!!!!!!

But i dont understand why this worked.............is there a simple explanation?

**Debraj Roy** · 07-01-2013, 07:28 AM

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.

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

**welchs101** · 07-01-2013, 07:38 AM

exactly the explanation i was looking for

thanks to both of you!

problem finding string using .find method when string to be found contains ~ (a tilde)

LinkBack

Thread Tools

Rate This Thread

Display

problem finding string using .find method when string to be found contains ~ (a tilde)

Re: problem finding string using .find method when string to be found contains ~ (a tilde)

Re: problem finding string using .find method when string to be found contains ~ (a tilde)

Re: problem finding string using .find method when string to be found contains ~ (a tilde)

Re: problem finding string using .find method when string to be found contains ~ (a tilde)

Re: problem finding string using .find method when string to be found contains ~ (a tilde)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions