Need to capitalized letters in spreadsheet

[phildoc]

Hi all,

I have an exported spreadsheet that I would like to capitalize all the letters prior to importing into my application. Can anyone provide help on this topic?

Phil

[tom1977]

use function =PROPER()

[NBVC]

PROPER capitalizes first letter of each word.

UPPER capitalizes all letters of all words.

choose your function.

[tom1977]

Right of course