caps to lower case

[dalearch]

I have some text that I copy and paste into Excel on a regular basis that is all caps. Is there a command - or a way to either change it to 1st letter only caps, or all small case - and then I can change the first letter manually?

[VBA Noob]

Take a look at proper or lower in excel help

e.g

=Proper(A1)

or using code.

Press Alt + F11 then insert code into a new module. Close VB editor then press Alt + F8 and select

Please Login or Register  to view this content.

or only the first letter

Please Login or Register  to view this content.

VBA Noob