how do i change a case to proper text in excel 2003

[BBD]

Please help, I need someone to help me change case to proper cases on an
excel spreadsheet.

 

[lk]

If your data is in cell A1,

=Proper(a1)