 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Delete Asterisk besides Numbers in a Cell
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. Try this: Precede the * with a tilde character: Edit>Replace Find what: ~* Replace with: nothing, leave this blank Replace All  SignatureBiff Microsoft Excel MVP > Hi, > [quoted text clipped - 13 lines] > Thanks a lot. > O.O. 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. > Try this: > [quoted text clipped - 8 lines] > Biff > Microsoft Excel MVP 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. SignatureBiff Microsoft Excel MVP > Thanks Biff. This works for me. By the way - what does the tilde > character do/mean i.e. what is its significance. [quoted text clipped - 14 lines] >> Biff >> Microsoft Excel MVP Thanks Biff for your explanation. This is something I did not know. Regards, Rio > 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 [quoted text clipped - 3 lines] > Biff > Microsoft Excel MVP 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. SignatureBiff Microsoft Excel MVP > Thanks Biff for your explanation. This is something I did not know. > Regards, [quoted text clipped - 8 lines] >> Biff >> Microsoft Excel MVP 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. > You're welcome! > [quoted text clipped - 6 lines] > Biff > Microsoft Excel MVP 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. ~? ~~ SignatureBiff Microsoft Excel MVP > Sorry, I did not notice that you had posted. > [quoted text clipped - 16 lines] >> Biff >> Microsoft Excel MVP
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.