using Tild char in find

[yankee428]

So when Excel couldn't find an add-in, it changed the funtion name to 'c:\program~\somedirectoery~\somedirectory'!funcitonname and this is causing me a headache. normally I would just load the addin and then find 'c:\program~\somedirectoery~\somedirectory'! and replace with nothing (if the directory path didn't just go away on it's own). I guess this doesn't work when the ~ tild character is involved. Additionally if you search only for ~ and click find all, Excel goes to IV65536??? What's going on there???

 

[Zack Barresse]

The tilde is usually used by Windows to shorten a fullname or address; it's more or less just a truncation method for viewing purposes. The address should not actually contain the tilde character.

Can you explain the real problem here? What is it that is going wrong?

 

[plettieri]

Hi:

Try placing * infront of ~

plettieri

 

[dk]

So when Excel couldn't find an add-in, it changed the funtion name to 'c:\program~\somedirectoery~\somedirectory'!funcitonname and this is causing me a headache. normally I would just load the addin and then find 'c:\program~\somedirectoery~\somedirectory'! and replace with nothing (if the directory path didn't just go away on it's own). I guess this doesn't work when the ~ tild character is involved. Additionally if you search only for ~ and click find all, Excel goes to IV65536??? What's going on there???

Hi,

The tilde character is an escape character. You use a tilde when you want to find one of the special characters (specifically ~, * and ?) using Excel's find functionality. For example, if you want to find the text *John then you would enter the text ~*John into the find dialog. If you want to search for a tilde then use two tildes e.g. to find the text c:\program~\my folder use the text c:\program~~\my folder in the find dialog. Similarly, if you want to search for text containing 2 tildes such as Da~~niel then use 4 tildes in the find box i.e. Da~~~~niel.

HTH
Dan

 

[yankee428]

Thanks to all!!! ~ ~