change non capitalized text to capitalized text

gebobs · #1 10-13-2014, 05:58 AM

You can use the UPPER formula to capitalize all the text in an adjacent cell then do a copy: paste text to the original columns.

antoniob · #2 10-13-2014, 06:45 AM

I used the formula and the text in the adiacent cell was capitalized, then I copy it but can't past because the name of the author is printed, not the title, like this
from
ALAN D. ALTIERIvictoria crossVICTORIA CROSS
to
ALAN D. ALTIERIALAN D. ALTIERIvictoria cross

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Spell check and grammar insists that a word should be capitalized, but it should not	x7lillies	Word	3	07-30-2014 02:02 PM
Select section of text and change text	newbieX	Word VBA	3	03-28-2014 04:21 PM
Is there a way to find CAPITALIZED words in a doc?	Bobosmite	Word	8	01-28-2014 03:53 PM
Formatting- Apply changes to highlighted text results in same change to other text	sential	Word	6	01-10-2014 03:22 PM
Out of Office can't change text	runiuksp	Outlook	0	05-18-2010 03:14 AM