 |
 | 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 / General Excel Questions / January 2008Find and Replace with wildcards?
Hello, I have data in a worksheet that has some number and some letter values sometimes followed by an asterisk. I am trying to find all entries of a number followed by an asterisk and format the cell and remove the asterisk. I am halfway there using find and replace but starting to think this may not be the best way to do it. Any help greatly appreciated. Thanks To find/replace an asterisk precede the asterisk by a tilde. ~* Gord Dibben MS Excel MVP >Hello, > [quoted text clipped - 5 lines] >be the best way to do it. >Any help greatly appreciated. Thanks Thanks Gord, I have got that far - I'm stuck on removing the asterisk only and leaving the value and also how to differentiate between numeric data and letters before the asterisk > To find/replace an asterisk precede the asterisk by a tilde. > [quoted text clipped - 11 lines] > >be the best way to do it. > >Any help greatly appreciated. Thanks You are using Replace from Excel's menu, right? Put ~* in the "Find what" field and remove anything in the "Replace with" field (this field should have nothing in it) then hit the Replace or Replace All button. Rick > Thanks Gord, I have got that far - I'm stuck on removing the asterisk only > and leaving the value and also how to differentiate between numeric data [quoted text clipped - 21 lines] >> >be the best way to do it. >> >Any help greatly appreciated. Thanks Thanks for your replies, I have managed to resolve my problem. I didnt explain myself fully and will make sure I do next time - thanks > You are using Replace from Excel's menu, right? Put ~* in the "Find what" > field and remove anything in the "Replace with" field (this field should [quoted text clipped - 27 lines] > >> >be the best way to do it. > >> >Any help greatly appreciated. Thanks |
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.