How do I convert a line of text to title case?

rcbjr2 · #1 09-15-2020, 02:47 PM

Quote:

Originally Posted by macropod

As posted, it appears you've converted the smart quote to plain quote.

Ok. Dumb question. How do I paste the smart quote? It may be that I copied the macro to a word doc so I could send it to myself at the office cause I can't access this forum at the office. Anyway, it seems to paste as plain text. Thanks.

macropod · #2 09-15-2020, 04:55 PM

Quote:

Originally Posted by rcbjr2

Ok. Dumb question. How do I paste the smart quote?

You could overtype the offending quote character with Alt-0147

rcbjr2 · #3 09-16-2020, 07:19 AM

Quote:

Originally Posted by macropod

You could overtype the offending quote character with Alt-0147

Thanks for the add'l info. I tried pasting it into the VBA editor at home and it worked fine so there's something lost in translation by my sending the code to the office so I'll send my template file home and past the code there, which I'm sure will then work.

-Rich

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating a new TITLE property from text already within document	smndnm	Word VBA	6	07-04-2014 08:27 PM
Stop review query when small case at beginning of line	dsrose	Word	2	01-22-2014 12:19 AM
True Title Case for First Row of All Tables	Marrick13	Word VBA	14	12-11-2013 09:12 PM
Custom Text Filter for this particular case	tinfanide	Excel	2	09-13-2011 05:08 AM
From all UPPER CASE to Proper Case	davers	Word	1	04-30-2009 12:41 PM