View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ephraim Ephraim is offline
external usenet poster
 
Posts: 15
Default Validate data but then change the entry to upper case

Hi,
Is it possible to validate data to allow only W, w, L, l and then
convert the lower case entry to upper case?
I don't want the user to have to keep pressing shift or caps lock
while entering data in these cells.
Ephraim