Hey all. I have an excel document with about 1,000 entries in the first column. Some are typed in all capital letters, some are lowercase. Does anyone know of anyway to autoformat all of these entries so it capitalizes the first letter of each name and changes the rest to lowercase?
Any help would be appreciated because I'd rather not have to re-type 1,000 names!! Thanks
Any help would be appreciated because I'd rather not have to re-type 1,000 names!! Thanks