How to replace "*" in Excel

In Excel, if you want to replace "*" with something else and you are using the "Find and Replace ..." menue item, it wont work because Excel thinks "*" is a wild card character. The trick is to use "~*", which is the escape character.

Another unannounced feature in Microsoft world.

Comments

Post a Comment

Popular posts from this blog

A lesson learned in SSRS 2005

I was working on some large SSRS reports for Project Server 2007. I found sum(column A + column B) is not same as sum(column A) + sum(column B). Because, if there is any Null value in columns A or B, the first one will generate #ERROR message and the second one will handle this better. Something you learned from elementary school is not sure any more in this complex world.
Read more