Software

Ask something
Discussion Locked

Excel 97 wildcard question

0 helpful
3 replies

by learneverything

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a long list with * in it. I want to remove the asterisks. But since they are a wildcard character, it finds everything. How can I find and replace a literal *?

3 replies

by awilliams3

Preceed the asterik * with a tilde ~.

Such as Test~* finds any instance of Test*, the literal asterik.

This discussion is closed to new replies.