View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_600_] Rick Rothstein \(MVP - VB\)[_600_] is offline
external usenet poster
 
Posts: 1
Default Capitalizing Text

Another way could be to use Data Validation, with a Custom formula

=EXACT(A1,UPPER(A1))

which will prevent any lowercase entry.


Well, except for a user who Copies/Pastes any text containing lowercase
characters into one of the cells with the validation formula you proposed.

Rick