How can I change the case of letters without using function ?
Hi,
Well you don't give too much detail but this may work for you
=proper(a1)
where A1 is the word to convert. If there are multiple words in A1 it will
capitalise the first letter of each word which may not be what you want.
Mike
"Rahim" wrote:
I am preparing a report in MS Excel with many sheets. I have typed it all
in capital letters. Now, I need to chage it to lower cases with the first
letter in capital. Pls tell me a tip to solve it.
|