PC Review


Reply
Thread Tools Rate Thread

Delete Asterisk besides Numbers in a Cell

 
 
O. Olson
Guest
Posts: n/a
 
      8th Mar 2008
Hi,

I have an Excel Spreadsheet with numbers. Some of the numbers have an
Asterisk besides them.
E.g.
324*

Is there a simple way to delete all Asterisk's in the entire
spreadsheet. (There are no other Asterisk's than these unwanted ones.)

If I use the Find and Replace i.e. search for * and keep the replace
thing blank - it deletes the entire sheet.

Any ideas?

Thanks a lot.
O.O.
 
Reply With Quote
 
 
 
 
T. Valko
Guest
Posts: n/a
 
      8th Mar 2008
Try this:

Precede the * with a tilde character:

Edit>Replace
Find what: ~*
Replace with: nothing, leave this blank
Replace All


--
Biff
Microsoft Excel MVP


"O. Olson" <(E-Mail Removed)> wrote in message
news:2c424a7a-bdd4-4d10-847e-(E-Mail Removed)...
> Hi,
>
> I have an Excel Spreadsheet with numbers. Some of the numbers have an
> Asterisk besides them.
> E.g.
> 324*
>
> Is there a simple way to delete all Asterisk's in the entire
> spreadsheet. (There are no other Asterisk's than these unwanted ones.)
>
> If I use the Find and Replace i.e. search for * and keep the replace
> thing blank - it deletes the entire sheet.
>
> Any ideas?
>
> Thanks a lot.
> O.O.



 
Reply With Quote
 
O. Olson
Guest
Posts: n/a
 
      8th Mar 2008
Thanks Biff. This works for me. By the way - what does the tilde
character do/mean i.e. what is its significance.

Regards,
O.O.

On Mar 7, 8:13 pm, "T. Valko" <biffinp...@comcast.net> wrote:
> Try this:
>
> Precede the * with a tilde character:
>
> Edit>Replace
> Find what: ~*
> Replace with: nothing, leave this blank
> Replace All
>
> --
> Biff
> Microsoft Excel MVP

 
Reply With Quote
 
T. Valko
Guest
Posts: n/a
 
      8th Mar 2008
In some uses the * is a wildcard character and Find/Replace is one of those
uses. The tilde character tells Excel that in this use the * is not a
wildcard but just a regular character.


--
Biff
Microsoft Excel MVP


"O. Olson" <(E-Mail Removed)> wrote in message
news:5063fa21-3e2f-44e4-b434-(E-Mail Removed)...
> Thanks Biff. This works for me. By the way - what does the tilde
> character do/mean i.e. what is its significance.
>
> Regards,
> O.O.
>
> On Mar 7, 8:13 pm, "T. Valko" <biffinp...@comcast.net> wrote:
>> Try this:
>>
>> Precede the * with a tilde character:
>>
>> Edit>Replace
>> Find what: ~*
>> Replace with: nothing, leave this blank
>> Replace All
>>
>> --
>> Biff
>> Microsoft Excel MVP



 
Reply With Quote
 
O. Olson
Guest
Posts: n/a
 
      8th Mar 2008
Thanks Biff for your explanation. This is something I did not know.
Regards,
Rio

On Mar 8, 11:47 am, "T. Valko" <biffinp...@comcast.net> wrote:
> In some uses the * is a wildcard character and Find/Replace is one of those
> uses. The tilde character tells Excel that in this use the * is not a
> wildcard but just a regular character.
>
> --
> Biff
> Microsoft Excel MVP
>

 
Reply With Quote
 
T. Valko
Guest
Posts: n/a
 
      8th Mar 2008
You're welcome!

That's why when you used just the * as the Find criteria Excel "deleted" the
entire sheet of data.

It interpreted that to mean Find *anything* and replace it with nothing.

--
Biff
Microsoft Excel MVP


"O. Olson" <(E-Mail Removed)> wrote in message
news:03794372-6827-48f6-b65f-(E-Mail Removed)...
> Thanks Biff for your explanation. This is something I did not know.
> Regards,
> Rio
>
> On Mar 8, 11:47 am, "T. Valko" <biffinp...@comcast.net> wrote:
>> In some uses the * is a wildcard character and Find/Replace is one of
>> those
>> uses. The tilde character tells Excel that in this use the * is not a
>> wildcard but just a regular character.
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>



 
Reply With Quote
 
O. Olson
Guest
Posts: n/a
 
      13th Mar 2008
Sorry, I did not notice that you had posted.

Thanks for your explanation. I figured out that Excel is taking my *
as a wild card - but I was looking for an option to enable or disable
the wild cards like we have in the MS Word Find dialog.

Thanks again.
O.O.


On Mar 8, 2:00 pm, "T. Valko" <biffinp...@comcast.net> wrote:
> You're welcome!
>
> That's why when you used just the * as the Find criteria Excel "deleted" the
> entire sheet of data.
>
> It interpreted that to mean Find *anything* and replace it with nothing.
>
> --
> Biff
> Microsoft Excel MVP

 
Reply With Quote
 
T. Valko
Guest
Posts: n/a
 
      13th Mar 2008
No option in Excel like that. All you can do is as I described, preceed the
wildcard with a tilde. This applies to the ? (question mark) and ~ (tilde)
wildcards as well.

~?
~~

--
Biff
Microsoft Excel MVP


"O. Olson" <(E-Mail Removed)> wrote in message
news:f37cd149-9a35-4873-ba59-(E-Mail Removed)...
> Sorry, I did not notice that you had posted.
>
> Thanks for your explanation. I figured out that Excel is taking my *
> as a wild card - but I was looking for an option to enable or disable
> the wild cards like we have in the MS Word Find dialog.
>
> Thanks again.
> O.O.
>
>
> On Mar 8, 2:00 pm, "T. Valko" <biffinp...@comcast.net> wrote:
>> You're welcome!
>>
>> That's why when you used just the * as the Find criteria Excel "deleted"
>> the
>> entire sheet of data.
>>
>> It interpreted that to mean Find *anything* and replace it with nothing.
>>
>> --
>> Biff
>> Microsoft Excel MVP



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i get an asterisk for 1st footnote and numbers after that? =?Utf-8?B?YmZqcGx0?= Microsoft Word Document Management 9 17th Jan 2007 11:44 PM
How do I delete numbers in a cell =?Utf-8?B?VGhlcmVzZQ==?= Microsoft Excel Misc 2 1st Dec 2005 10:22 AM
asterisk in a cell =?Utf-8?B?Q2Fyb2xpbmU0MQ==?= Microsoft Excel Misc 2 30th Nov 2005 05:28 PM
Re: Add asterisk to excel cell Bob Tarburton Microsoft Excel Worksheet Functions 0 8th Mar 2005 06:25 PM
How delete a file with an asterisk in the filename? Thomas Podlesak Microsoft Windows 2000 File System 3 14th Oct 2003 07:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:57 PM.