Can you delete all asterisks in a sheet?

  • Thread starter Thread starter REMB
  • Start date Start date
R

REMB

I have a spreadsheet with asterisks on certain entries. Is there any way to
delete these?
 
Edit --> Replace
enter an asterisk ( * ) into the find what,
leave the replace with empty
[Replace All]

I'd make a copy of the book before doing this, just in case you discover you
really didn't quite mean ALL of the * entries.
 
Hi,
you can use find and replace, Highlight the whole sheet, then press CTRL +
H, find what enter *, go to replace with but do not enter anything, then
press replace all
 
Hey, mine worked in my special case (just * entered into a few cells). Oh
well....
 
And yours did get rid of all the asterisks, too. It may have done a bit more
 
yeah, I realized that once I saw Gord's posting. Goes to show you that given
bad test data, even the worst solution may APPEAR to work great.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Asterisk pointing to a footnote 3
Asterisk is missing from list 2
Replacing all asterisks in Excel 2003 spreadsheet 3
Find and Replace with wildcards? 4
Delete Asterisk besides Numbers in a Cell 7
Input box with asterisks 2
Remove asterisk from column with text only 4
Replace many asterisk characters, '*' in Excel 4

Back
Top