Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How to remove an asterisk from cells in excel?
I have an spread sheet that auto-updates numerous parts from websites. Parts of these are ext cells (NHL Team names) that are used in a filtering process, but the filter hinges on the text of these cells. When a team becomes playoff eligible an asterisk is placed after the team name (i,e. CHICAGO BLACKHAWKS becomes CHICAGO BLACKHAWKS*). Since these cells auto-update and it is used in sports stats filtering, where these teams will be placed in cells changes daily. I do have filters made to select the teams I am looking for, but this asterisk changes the initial search.
The way the spreadsheet works prevents really using an OR function (though possible) since it would require ALL 30 teams to be dedicated to the filter, and this would be cumbersome. Does anybody know of a way to either strip the asterisk or at the very least strip the asterisk and the filtered text placed in a new cell?
7 Answers
- C MastersLv 610 years agoFavorite Answer
well you can strip the asterisk out of text using
=SUBSTITUTE(A1,"*","") (where A1 is the location of the text)
so you could probably use that to clean your new data before it goes into the cells that are use din the filter.
depending on how you are importing the data from the websites you should also be able to clean it before it is inserted into the cells, or maybe use a macro to remove the asterisks in predetermined cell ranges
if the SUBSTITUTE option isn't quite what you want , write an update with some more info and you'll get more answers
hope that helps
- 10 years ago
Use Excel 'Help'
Search 'Help' for the term "string".
You should get a listing of various Excel functions that deal with strings of text, etc.
Depending on the specific cell contents and how you want the text displayed, choose the string function(s) best suited to your spreadsheet application.
Source(s): Excel Help - How do you think about the answers? You can sign in to vote the answer.
- Anonymous5 years ago
If you wish to discover ways to gain at betting sports then this really is your place https://tr.im/u6wLI with Zcodes System.
Zcodes System is all about teaching you how to become sound principled sports investor and learning from a team of proven pickers who encompass you. The theory moves that should you surround yourself with the good energy of earning people in the sports betting business then you definitely also will even emerge on top yourself.
Zcodes System can be treated as a mastermind for activities fans to push minds and rise to profitability together.
- 5 years ago
If you want to try new things and win income with betting activities then Zcodes from here https://tr.im/Vcy01 can allow you to.
What's intriguing concerning the authorities on Zcodes is that most are simply normal men who were consumers of another methods on the site ahead of creating their very own methods from their new winning perception and the data analysis. They then reveal their successes and provide back again to town that created them.
Zcodes will really assist you to win your bets.
- Anonymous5 years ago
You can use Find and Replace - Find What: ~* Replace with: "" Or you can use a formula to keep the original values in one column and get a list of the new values in another: =Substitute(A1,"*","")
