In $2005$ critics Lev Grossman and Richard Lacayo from Time Magazine published their list of the top $100$ English$-$Language novels published from $1923$ to $2005.$ The table on the Text Functions worksheet details their list. Your task is to manipulate the text in the "Raw Book Information" column of the table to fit a different bibliographic format. Specifically, you need the books to be listed with the year first, followed by the book title in upper case, and ending with the author. For example the citation for the first book should be formatted as $"1953.$ THE ADVENTURES OF AUGIE MARCH. Saul Bellow". Complete the table to help you make the transformation using the built$-$in text functions available in Excel.