Anyone know how to format cells/columns to always show a title be formatted looking like.... "Title, The"?? For example, the movie title "The Replacements" or music artists "The Beatles" to automatically format to look like "Replacements, The" and "Beatles, The". My intentions are to make lists...
I am amazed at the things that I have seen on this forum - what you can do with excel is incredible.:)
I have many worksheets (40-50) from different sources with some or all of the information I need (language problem-community development work).
The worksheets provided to me do not have all...