Can you change case settings on excel as easily as on word

[Pete_UK]

Don't try to fit your question just in the heading - use the white
space here to elaborate.

In Excel you can use these functions:

LOWER (to produce all lower-case letters)

UPPER (to produce all upper-case letters)

PROPER (to produce lower-case with initial capitals)

Hope this helps.

Pete