Software

Ask something
Discussion Locked

Find and replace

0 helpful
5 replies

by hunterzh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In Excel 2000, normally we can use find and replace, to change some characters quickly, for example, all "words" into "word". We can use mask like "*", but now I need to change all "*" (asterisk) into "x", how can I replace all "*"?

5 replies

by konza

In the find field, enter the tilde character (~) before the asterisk and it will find and replace only the asterisks.

by konza

Dang, DKlippert beat me again. Maybe D can answer the question I am about to post.

This discussion is closed to new replies.