Home |
Search |
Today's Posts |
#1
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
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
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
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you delete all asterisks in a sheet?
Congrats.
You are the only responder who got it right<g Gord On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student wrote: Use Find/Replace Find ~* Replace with nothing |
#6
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 right<g Gord On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student wrote: Use Find/Replace Find ~* Replace with nothing . |
#7
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 right<g Gord On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student wrote: Use Find/Replace Find ~* Replace with nothing . -- Dave Peterson |
#8
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 right<g Gord On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student wrote: Use Find/Replace Find ~* Replace with nothing . -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum function with asterisks | Excel Worksheet Functions | |||
Finding asterisks | Excel Discussion (Misc queries) | |||
Input box with asterisks | Excel Discussion (Misc queries) | |||
Asterisks in Excel | Excel Discussion (Misc queries) | |||
Delete asterisks from text in cells? | Excel Worksheet Functions |