|
| 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
May 12th, 2010, 03:11 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
May 12th, 2010, 03:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 12th, 2010, 03:18 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 12th, 2010, 03:18 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 12th, 2010, 08:30 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 12th, 2010, 10:10 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 12th, 2010, 10:45 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 14th, 2010, 02:38 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
