Hi there!
I've got a large spreadsheet of captions to cartoons. The cells all begin with a single straight 'dumb' quote, and end the same way. I'd like to be able to replace them with double 'smart' quotes.
I'd normally do just a find and replace, except that I've also got contractions that obviously can't be double quotes.
Any idea on how best to do this?
If your text starts in A2:
Please Login or Register to view this content.
Last edited by tlafferty; 08-25-2011 at 03:05 PM. Reason: Start mid at position 1 and add quotes
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
That got rid of the first quote, how to get rid of the end quote? And then how should I add new "smart" double quotes at each end?
Thanks so much!
Without seeing exactly what's in the cell, ...
=CHAR(147) & MID(A1, 2, LEN(A1)-2) & CHAR(148)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks