New to all this, so if I've done it wrong, tell me!
EXCEL for MAC:
I have a long (3000 names) mailing list stored as data in columns, of course.
In combining lists, some of the address entries are in Caps others in Upper and Lower case.
Is there any command to format existing column content, for example, to ALL CAPS or UPPER case? Or better yet, the content to Title case. Microsoft word offers "Change Case" with a variety of choices. Is there something similar I can't find for Microsoft Excel?
I did find functions for UPPER and LOWER but can't see how to apply them to a column or group of cells.
Changing it one cell at a time is too ugly to even think about.
Thanks to all who take time to consider this.