Software

Ask something
Question Locked

Replacing Wildcards in MS Excel

0 helpful
3 replies

by rayasta

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all!

I was trying to replace the character "*" in MS Excel. The "traditional" way does not work (write * in the Replace box).

Does anybody know how to replace a wildcard in Excel?

I found a way (change the file to .txt, make a find and replace and then go back to Excel), but I believe there should be a way to do it in Excel itself.

Any advice is welcome.

Thanx!

3 replies

by Member 25348569

Enter ~* and away you go. To replace a tilde, use ~~.

You know, you could have googled the answer in less time than it took you to type the question in here!

I think you owe me a "helpful answer tick" for giving you the answer [b]and[/b] a small, but deserved slapping. Normally, I wouldn't be this nice and you'd just get the slap...

:D

by rayasta

I think I made something wrong yesterday since I couldn't find it in Google.

Totally deserve the slap!! :(

This discussion is closed to new replies.