proper case a a whole range

[Trevor3007]

hi.

data in the range i3:i8000

is there away to force the data alredy in the above range to lowercase ?(i have put some code in so future any data entered will do this)... is there a way to do this without having to change each line manually?

MTIA

 

[Trevor3007]

hi,

thanks for your help. have gotten some VB that has sorted, but very much appreciated your help.

hoping oy have agreat day.