If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can you delete all asterisks in a sheet?
I have a spreadsheet with asterisks on certain entries. Is there any way to
delete these? |
#2
|
|||
|
|||
Can you delete all asterisks in a sheet?
Use Find/Replace
Find ~* Replace with nothing -- Gary''s Student - gsnu201002 "REMB" wrote: I have a spreadsheet with asterisks on certain entries. Is there any way to delete these? |
#3
|
|||
|
|||
Can you delete all asterisks in a sheet?
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. "REMB" wrote: I have a spreadsheet with asterisks on certain entries. Is there any way to delete these? |
#4
|
|||
|
|||
Can you delete all asterisks in a sheet?
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 "REMB" wrote: I have a spreadsheet with asterisks on certain entries. Is there any way to delete these? |
#5
|
|||
|
|||
Can you delete all asterisks in a sheet?
Congrats.
You are the only responder who got it rightg Gord On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student wrote: Use Find/Replace Find ~* Replace with nothing |
#6
|
|||
|
|||
Can you delete all asterisks in a sheet?
Hey, mine worked in my special case (just * entered into a few cells). Oh
well.... "Gord Dibben" wrote: Congrats. You are the only responder who got it rightg Gord On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student wrote: Use Find/Replace Find ~* Replace with nothing . |
#7
|
|||
|
|||
Can you delete all asterisks in a sheet?
And yours did get rid of all the asterisks, too. It may have done a bit more
vbg, too! JLatham wrote: Hey, mine worked in my special case (just * entered into a few cells). Oh well.... "Gord Dibben" wrote: Congrats. You are the only responder who got it rightg Gord On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student wrote: Use Find/Replace Find ~* Replace with nothing . -- Dave Peterson |
#8
|
|||
|
|||
Can you delete all asterisks in a sheet?
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. "Dave Peterson" wrote: And yours did get rid of all the asterisks, too. It may have done a bit more vbg, too! JLatham wrote: Hey, mine worked in my special case (just * entered into a few cells). Oh well.... "Gord Dibben" wrote: Congrats. You are the only responder who got it rightg Gord On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student wrote: Use Find/Replace Find ~* Replace with nothing . -- Dave Peterson . |
Thread Tools | |
Display Modes | |
|
|