Can you delete all asterisks in a sheet?
in [General]
|
From: REMB on 12 May 2010 10:11 I have a spreadsheet with asterisks on certain entries. Is there any way to delete these?
From: Gary''s Student on 12 May 2010 10:17 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?
From: JLatham on 12 May 2010 10:18 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?
From: Eduardo on 12 May 2010 10:18 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?
From: Gord Dibben on 12 May 2010 15:30
Congrats. You are the only responder who got it right<g> Gord On Wed, 12 May 2010 07:17:01 -0700, Gary''s Student <GarysStudent(a)discussions.microsoft.com> wrote: >Use Find/Replace > >Find >~* > >Replace with nothing |