Ok so I have a list of numbers all ending in * and I want it removed. I know in the past I can highlight the row, go to edit menu select find, I type * in the find what area, click replace and than select replace all it will remove it but this list when I do that it removes the entire list. Any help?
Last edited by sp1974; 05-21-2010 at 04:17 PM.
Use the tilde before the asterisk to replace and actual asterisk..
e.g. Find What: ~*
Replace with: (leave blank)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
worked like a charm. Just out of curiousity what is the difference between me doing it with just * and your way with ~*. Or maybe to make it easier why do I use the ~? Thanks!
The * (and the ?) are wildcards in a search. So when you search for *, you're getting everything (? represents a single letter, * any # of characters). The tilde ~ tells Excel that you want to search specifically for the * and not to use it as a wildcard.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
thanks! Wasn't aware of that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks