Identifying small letters at the beginning of words
Hello,
Got a quick Excel question to help me rename my files.
Basically, I have all my music titles listed in Excel down column A. I want to find if there are any words beginning with a small letter so that I can capitalise it and fix it.
I have tried using =proper(A1) in column B and then doing =A1=B1 to see if there's any difference, but that doesn't work because Excel counts small letters the same as capital letters!
Thank you in advance.
Suptilitas
Last edited by Suptilitas; 11-06-2011 at 02:51 PM.
See the EXACT function; e.g., =EXACT(A1, PROPER(A1))
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks