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.
|