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:
=""""&MID(A2,1,LEN(A2)-1)&""""
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 here to see how.
Also, you might want to add to the user's reputation by clicking the scales icon - 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)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks