General discussion

Locked

Find and replace

By Hunterzh ·
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 "*"?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Find and replace

Use a tilde

to replace *
type
~*
in the Find what box

Collapse -

by DKlippert In reply to

For Konza:
The answer is re-format

Collapse -

by Konza In reply to Find and replace

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

Collapse -

by Konza In reply to

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

Collapse -

by Hunterzh In reply to Find and replace

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums