You can simply use =StrConv("MY unpropER CASE LiNe", vbProperCase)Reference for strconv ...http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.strings.strconv(v=VS.80).aspx