validation rule - force text entries to appear as Proper
Is there a way to force text entries using Data validation such that any
entries will appear in the Proper format? test = Test Test= Test Thanks! |
validation rule - force text entries to appear as Proper
A couple of ideas. You can either use data validation to warn them
that the first word is not proper or you can always force it to be proper using VBA. With VBA: Put this in the worksheet module of the sheet you are affecting: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ErrorHandler Target.Value = Application.WorksheetFunction.Proper(Target.Value) ErrorHandler: End Sub Or with data validation use custom and then put this formula in: =and(Code(A1)=65, Code(A1)<=90) |
All times are GMT +1. The time now is 01:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com