|
|
|
|
#1
10-13-2014, 08:55 AM
|
|||
|
|||
OK...so it looks like you have three columns of data: Author, Title, and then Title again. I'm not sure why Title is repeated and not sure also if you have capitalization issues with all three.
Assuming you do, in Columns D-F, enter the UPPER formulas referencing the data in A-C (as attached). Then copy the data in D-F and Paste Text Only to A-C. Once this is done, you can delete D-F. 
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode