 |
 | 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 / March 2008find replace excel remove single character
Excel 2007. Big spreadsheet. 15000 rows. One column has for some reason randomly added a question mark at the end of a bunch one word text in this column (they're brand names). I want to replace the ? with a blank space. When I do it, though, I end up with a blank cell. There must be a way to just take out all the question marks in column B. What am I missing? Thanks. The question mark is a joker that replace any character (including itself). To limit its range of action to only genuine question marks, use ~? instead of ? > Excel 2007. > [quoted text clipped - 9 lines] > > Thanks. So in the Find I tried putting ~? and it says it found nothing. What would I put in the Find field? > The question mark is a joker that replace any character (including itself). > To limit its range of action to only genuine question marks, use ~? instead [quoted text clipped - 13 lines] > > > > Thanks. Forget my last question - got that to work. I had to clear the format. Thank you, thank you, thank you. > The question mark is a joker that replace any character (including itself). > To limit its range of action to only genuine question marks, use ~? instead [quoted text clipped - 13 lines] > > > > Thanks. Hi Alaska Boy, ? is a wildcard character try it this way ~? in your find/replace HTH Martin > Excel 2007. > [quoted text clipped - 10 lines] > > Thanks. Yes, thank you - that worked. Thanks for your help. > Hi Alaska Boy, > [quoted text clipped - 18 lines] > > > > 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.