Share via

Using Ctrl + H replace window for Excel. What are all possible ways to filter out and replace cell values?

Anonymous
2015-01-31T11:03:08+00:00

So I have searched online on different ways to use Ctrl + H and would like to know ways to use the asterisk * in the replace window. I think there is a way to tell it to replace what is in a cell for a specified range of values with the asterisk. I would like to know several alternatives in using this neat function. Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-01-31T13:13:56+00:00

Hi

Just place a tilde ~ before the asterisk in the Find what box

Find what   ~*

Replace with ???

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest