 |
 | 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 / August 2007Find & Replace apostrophes in text
Hello, I have a worksheet that has some long text in a column of cells. Some of the words contain right-slant apostrophes ( ’ ) which cause problems with the program that imports this data. Since there are many instances of this character that I need to replace with a standard apostrophe ( ' ), I thought I would do a find & replace to clean up the data. However, Excel will only find this character if I tell it to find in the "values". The replace only allows me to search on "formulas" and therefore doesn't find the characters to be replaced... Also, I have discovered that if I do get it to find some text it then complains about the formula being too long... Anyone know a solution to these problems? Thanks! Ian Have you tried dragging the mouse over the right-slant apostrophe, copying it, then used find & replace and pasting the RH apostrophe in the find box? John www.magicspreadsheets.com > Hello, > [quoted text clipped - 15 lines] > > Ian Yes. That's what I've been doing and Excel finds no matches. It will work if I "Look In" values during a Find. But when doing a Replace, I only get the option to "Look In" formulas. It can't seem to find the character in formulas. Thanks, Ian > Have you tried dragging the mouse over the right-slant apostrophe, copying > it, then used find & replace and pasting the RH apostrophe in the find box? [quoted text clipped - 22 lines] > > > > Ian I have not tested it but you could try using the tilde character in front of the apsotrophe. The tilde (~) allows you to look for special characters like the astrix...  SignatureHTH... Jim Thomlinson > Yes. That's what I've been doing and Excel finds no matches. It will work > if I "Look In" values during a Find. But when doing a Replace, I only get [quoted text clipped - 31 lines] > > > > > > Ian you might check an excellent add-in from cpearson(dot)com[substitute . for dot cell view then you can type in even not printing characters and find/replace works- very helpful if importing data from websites that may have funky formating > I have not tested it but you could try using the tilde character in front of > the apsotrophe. The tilde (~) allows you to look for special characters like [quoted text clipped - 35 lines] > > > > > > > > Ian I really need to do this w/o an add-in since I'm going to need to pass this information on to an analyst who will be making the actual changes. I'd prefer to not have to tell them to go install something... But, I'll certainly keep this in mind if there's no other solution. Thanks! Ian > you might check an excellent add-in from cpearson(dot)com[substitute . for > dot cell view then you can type in even not printing characters and [quoted text clipped - 40 lines] > > > > > > > > > > Ian I'd already tried that too. Doesn't work. Thanks, Ian > I have not tested it but you could try using the tilde character in front of > the apsotrophe. The tilde (~) allows you to look for special characters like [quoted text clipped - 35 lines] > > > > > > > > Ian |
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.